Advanced Filtering
On this page
The Advanced Filter option allows users to precisely sort data within the tables throughout Matrix. While each column is equipped with its own search bar, the Advanced Filter option provides access to narrow down more specifically what information is displayed.
Perform the following steps to create and apply an advanced filter to tables.
- Select Advanced Filter from the toolbar options.
- Select AND or OR from the filter type drop-down.
- AND matches all information fitting the criteria.
- OR matches any single information fitting the criteria.
- Select the
+
icon to add search criteria.- Continue to step 5.
- Continue to step 5.
- Select the
+{}
icon to add a filter subgroup (additional AND or OR criteria that should be met). - Select the desired information the table data should be filtered by from the criteria drop-down.
- Select the desired rule the search should follow when filtering data from the parameter drop-down.
- All available parameters and their definitions can be found below.
- All available parameters and their definitions can be found below.
- Input the desired variable data should be filtered by given the set parameters into the text field.
- If a subgroup was added, repeat steps 5-7 for the subgroup as well.
- Select Find to complete the search.
- Select Reset to clear all entered criteria and begin from step 2.
The table will refresh with the data that meets your entered search criteria.
Available Filter Parameters
Type | Definition |
---|---|
Equal | The search will only return data that matches the entered criteria exactly. |
Not Equal | The search will only return data that does not match the entered criteria. |
Less | For numeric searches. The search will return data containing numbers less than the entered criteria. |
Less or Equal | For numeric searches. The search will return data containing numbers equal to or less than the entered criteria. |
Greater | For numeric searches. The search will return data containing numbers greater than the entered criteria. |
Greater or Equal | For numeric searches. The search will return data containing numbers equal to or greater than the entered criteria. |
Begins With | The search will return data that starts with the entered criteria. |
Does Not Begin With | The search will return data that does not start with the entered criteria. |
Ends With | The search will return data that finishes with the entered criteria. |
Does Not End With | The search will return data that does not finish with the entered criteria, |
Contains | The search will return data that includes the entered criteria. |
Does Not Contain | The search will return data that does not include the entered criteria. |
Is Null | The search will return data where the selected search criteria field was left blank. |
Is Not Null | The search will return data where the selected search criteria field is populated with information of some kind. |
Is In | This option is not currently in use. |
Is Not In | This option is not currently in use. |