Grouping and Filtering data
Each Data Grid in Trigger-it could be filtered and grouped in the same way, this section explains how to group and filter data.
Grouping by certain field
If you want to group a grid using a certain field, you can simply drag the field using its header to the grouping field as below:
This will result in the grid to be grouped using the OS field:
You can drag additional columns to the grouping panel to group sub-field, for example to group computers with OS type then last logged in user, drag the last logged in user field as a sub field:
You can right click on any field to perform grouping operation like sorting, collapsing or expanding data.
Filtering Data
Each grid contains various ways to filter data to meet most demanding and sophisticated requirements, this section lists the available options to filter data.
Filter data using Field Filtering
Clicking on the small filtering icon on each field brings the data filtering screen which allows you to select values
If you want to use wild cards or advanced filtering capabilities, you can you choose the Text Filters tab and choose your filtering option.
Filtering using the Filter Bar:
To quickly filter fields, you can use the filtering bar to filter fields
Highlighting and Finding Data
You can highlight in two ways on every grid
Using the global find box
You can use the global find box to find data quickly and highlight them, for example, to find machines with OS that includes “Windows” just type Window in the find box:
Using the Conditional Formatting rules
You an use conditional formatting rules to highlight cells with certain values and either highlight the cell or the entire row (same as excel), to do so, right click on any field and choose the conditional formatting menu and create your rule:
