Avantis offers powerful tools to sort, multi-sort, filter, and group your columns. For the most effective use, we recommend paying special attention to Grouping Your Search Results (see Grouping Search Results). Below are step-by-step instructions to help you get started with filtering your search results.
Important Note: Filtering your view vs narrowing your search
- Filtering only filters among the options already displayed in your result grid
- Filtering does not re-run your search and retrieve any new results from the server - it only limits your view of the results you are already seeing
- Filtering will never display any new results not already in your grid
- To get new results not currently displaying in your grid, narrow your criteria selections up top and re-run your search
- Quick filter in grid
- Expanded filter options
- Type ahead to filter by text
- Search to find values
- Build compound filtering commands
Video: Filtering Your Search Results
How to Filter Your Result Grid:
Method 1 - Using the Global Filter
-
Click on the global filter above your results grid (under the Page number indicator)
-
The Global Filter allows you to filter across all columns simultaneously
-
Text will be matched against all rows and columns at once and any row that has matching text in any column will display.
Method 2 - Using the Column Filter Fields
-
Click into the empty filter fields at the top of any column and type in any value you'd like to filter on
-
Any row that has that value in that column will display.
Method 3 - Using the Column Filter Icons
-
Click on the column filter icon on the right of any column filter field.
-
Use the checkboxes
- Unclick Select All checkbox and choose which values you want to include
-
Use the text filter
- Click on Text Filter >
- Choose your relationship (contains, starts with, etc.) and type in any value you'd like to filter on
- Any row that has the selected values will display