Advanced filtering has been introduced to create your own set of rules, conditions and groups to filter data from the grids.

Follow these instructions to use Advanced Filtering options,

1. Log in to the iCare application and navigate to the page you wish to filter the data for. Search for the Advanced Filter icon in the Smart Search bar and click it.

2. Advanced filtering menu will open on your screen with various options to create conditions, add rules/groups, and filter.

3. The drop-down contains the list of the columns of the grid you are filtering the data for. Select a column, select a condition and enter a keyword. Click Filter button to filter the data.

4. When you click on add rule, a new drop-down will add in the menu and you may set the filter for two columns by adding a rule.

5. When you click add group, a sub-group will be created.

6. To view the SQL query you just created, click the SQL Result button,

7. Once you have created your set of conditions click the ‘Filter’ button to filter data from the grid. Click Close to finish.