Using grids in EVOLVE
- Record Navigator
- Relevant Articles
This document is intended to help navigate through DevExpress grids. While the document may not go over all available options it should help to provide a basic understanding to help better utilize the functionality of the DevExpress grids. The functions and processes contained within this document are not product specific and may be applied to all eVolve software.
The GridView is the default Data Grid View that displays data in a traditional tabular format. Each data source record is represented as a row, and all data source data fields have related columns. Data portions are stored within individual cells.
Columns can easily be reordered by dragging them to a new location. With the mouse, click and hold on the column header then drag the header to the left or right. As the header is dragged over other headers, arrows appear indicating available spots. Once the header is in the desired location release the mouse button.
Right-click on unwanted column's header and click Hide This Column.
To restore hidden columns
- Right-click on any column header and click Column Chooser. A Customization panel appears.
- From the Customization panel, with the mouse, click and hold on the column header then drag the header to the header row in the grid. As the header is dragged over other headers, arrows appear indicating available spots. Once the header is in the desired location release the mouse button.
To group data by a column, drag a column header into the Group Panel.
Another option is to right-click a column header and select Group By This Column.
To ungroup data, drag a column header from the group panel to the column header panel.
Another option is to right-click a column header and select Ungroup from the context menu.
To remove all grouping, right-click the group panel and select Clear Grouping.
When data is grouped by multiple columns, you can drag a column header to another position within the group panel to change the group order.
Merged Column Grouping
Hold the Ctrl key when dragging column headers into the group panel to group data by multiple columns at once.
Compare how the row information is displayed as compared to the image above.
TIP: To re-arrange column headers within merged filter blocks, drag a column header while pressing the Ctrl key.
By default, data may be sorted by any column. Click a column header once to sort data ascending. Consequent clicks will reverse the sort order. Sort glyph (up or down arrow) in column headers indicates the current sort order.
To sort data by a specific column, right-click the column's header and select Sort Ascending or Sort Descending.
The Data Grid discards the currently applied sorting when a column header is clicked and keeps the sorting when applied through header’s context menus. Thus, to sort data by multiple columns, either utilize header context menus or hold the Shift key down when clicking column headers.
In the image above, note how Tag Type is sorted ascending, Category is sorted descending, and Service Type is sorted ascending.
- Save Grid State -
- First - Selects the record at the top of the grid.
- Previous Page - For grids, a page is considered all records displayed within the bounds of the current grid. This function fills and displays the records of the preceding page as if you were to scroll up.
- Previous - Selects the record above the currently selected record in the grid.
- Record indicator - displays the numerical value of the currently selected record and the total number of records in the grid.
- Next - Selects the record below the currently selected record in the grid.
- Next Page - For grids, a page is considered all records displayed within the bounds of the current grid. This function fills and displays the records of the succeeding page as if you were to scroll down.
- Last - Selects the record at the bottom of the grid.
- Add New - Used to create a new record.
- Delete Selected - Used to remove existing record(s).
- Export to Excel - Used to export the grid as currently displayed in a .xlsx format.
Conditional Record Navigator buttons
Some of the eVolve grids have different data and functional requirements. While most of the eVolve grids do have and share common functionality, the following buttons may or may not appear in the Data Navigator.
- Bulk Update - Used to update parameter values for the selected records.
- Duplicate - Used to copy the record currently in focus or records that are currently selected in applicable.
- Export to Data Tables - Sends the information currently displayed in the grid to Data Tables.
NOTE: hidden columns are not exported.
When filtering is applied to a View, displayed records are restricted to those that meet the current filter criteria. Data may be filtered against single or multiple columns.
Filtering Dropdown Menus
To invoke a filtering dropdown menu for a column, click the filter icon within the column header.
In the Values tab, users can select specific cell values from those that are currently displayed by the Data Grid.
The Filters tab gives users a wider pool of filtering options. For example, when filtering by dates, you can only show those records that correspond to the previous week.
The content of a filtering dropdown menu depends on the type of data displayed by the related grid column. For instance, the figure below illustrates what this menu looks like when filtering by a text column.
While some features may not be applicable, you can view more information about grouping, sorting, and filtering DevExpress grids on the DexExpress website.
When filtering is applied, a View shows a filter panel. The Filter Panel is used to modify and remove current filters.
The Filter Editor dialog allows end-users to build complex filtering criteria, combined from multiple expressions. To invoke this dialog end-users can do one of the following:
· click Edit Filter in Filter Panel
· right-click a column header and select Filter Editor
For more information about the Filter Editor may be found on the DexExpress website.
Searching in grids - using the Find feature