Using and customizing the grids- Part I
How to use the Grids and customize in Drova:
This topic is divided into three parts. Please see the links for the other articles in relation to customizing grids:
Grid Elements
Drova GRC grids offer many options to arrange, sort, filter and group its rows and columns.
This is a sample grid with all the elements highlighted:
‘Grid Elements’
Highlighted Grid Elements
|
Highlighted Grid elements |
||
|
ID |
Element |
Description |
|
1 |
Page Navigationpanel |
Use this panel to display different pages in the list and to set the number of Records to display per-page. This panel is duplicated at the bottom of the grid. |
|
2 |
Text Search |
Enter text to search all displayed columns and filter to only display matching rows. |
|
3 |
Group By Column |
Drag column headers here to group by those columns |
|
4 |
Clear Filters |
This icon indicates if a filter is applied to the grid. The filter applied is shown at the bottom of the grid 8 |
|
5 |
Column Headers |
Use the controls in the Column Headers to filter or sort the Records in the list. These filters will be displayed in the Filters applied 8. Column Headers can be dragged to change the order of Columns in the grid. |
|
6 |
Hide/Show Column Chooser |
Hover over the Menu icon to reveal options. Click this icon to display the Column Chooser window). |
|
7 |
Export to Excel |
Hover over the Menu icon to reveal options. To export the listed Records to a Microsoft Excel file, hover over this icon and select either the Standard export or the With filters option. |
|
8 |
Show Advanced Filters |
Hover over the Menu icon to reveal options. Click this icon (and link) to display the Filter Builder window. The filter applied is shown at the bottom of the grid 8 |
|
9 |
Layoutspanel |
Save, update, load, delete and reset grid Layouts. |
|
10 |
Vertical scroll |
Click and hold the scroller to see the other columns in the grids. |
Page Navigation
Page Navigation PanelUse the Page Navigation panel to navigate through multi-page lists.
Page Navigation Elements
|
Page Navigation Elements |
||
|
ID |
Element |
Description |
|
1 |
Page Status Indicator |
Displays the current page, number of pages and the total number of items in the list. |
|
2 |
‘Previous Page’ icon |
Click to display the previous page. This icon is disabled when the first page is displayed or there is only one page. |
|
3 |
‘Page Selector’ |
Click a page number to display that page. The displayed page is highlighted. The number of page numbers displayed is determined by the number of records divided the Page size. |
|
4 |
‘Next Page’ icon |
Click to display the next page. This icon is disabled when the last page is displayed or there is only one page. |
|
5 |
‘Page Size’ Selector |
Choose the number of list items to display per-page from the drop-down list. The current selection is display in the selector. |
|
6 |
‘Page Size’ Selection |
When the Page Size Selector is clicked, the available selections are displayed; this selection may vary for each grid. The higher the number of records selected may require more time to load the page. |
|
7 |
‘Page Size’ All |
When All is selected as the Page size, all records are loaded onto page 1. This selection may not be available on all grids. A large amount of records may require more time to load the page. |
Text Search
Enter text to searchUse the Text Search field to search all text displayed in all columns in the grid.
Enter text into the Text Search field 1
to search all columns displayed in the grid. In this example, the word ‘compliance’ is entered as the search text; when at any point you pause typing in this field, the search will commence (if you want to type more letters, you must wait for the search to complete, before typing some more).
The bouncing balls 2 in Drova colours indicates that the search request is being processed.
Each occurrence of the text 3
will be highlighted. Only rows containing an occurrence of the text will be displayed; In our example, the text ‘compliance’ is being highlighted.
Clear the search by removing the text from the Text Search field or by resetting the grid layout.
Note: The Clear Filters icon clears Column Header filters only; it does not clear this Text Search field.
Related Articles
Using and customizing the grids- Part II
Hide/Show Column Chooser Column ChooserAll (unpinned) columns can be displayed or removed from a grid using the Column Chooser. Column Chooser Click the Column Chooser icon to display the Column Chooser window. The Column Chooser window contains ...Loading values using an Excel Spreadsheet into a KRI
To load values from a spreadsheet into a KRI, that KRI must have Load values using a spreadsheet option selected shown as below: Note: Spreadsheet column headings must match exactly as shown in the following images. Format all Spreadsheet cells ...How to set up a Task using Predefined Tasks
⚠️ This is only applies in the Events and Registers modules Are you setting up a task with a predefined task template created by your Register Owners/System Administrators? Our system provides the feature to predefine tasks as a preset template which ...Step by Step procedure to add a new Register record using the GRC Portal
Procedures There are two ways to create new Register records. Via the Portal, or via the main GRC site. Drova GRC users are able to create register records both ways, however those only added to Portal can only create a new record via the Portal. ...What are layouts and how to manage them?
Layouts LWhen you have completed customising a grid using the Column Chooser, you can save this grid layout. Multiple layouts can saved and each layout can be reloaded at the required time. 1 ‘Saved Layouts’: Select from previous saved layouts to ...