Advanced filters reference
Reference for the fields and operators available when you build advanced filters queries on ISPM inventory pages.
About advanced filters
Early Access release
Advanced filters let you construct compound queries against ISPM inventories beyond what the basic column filters support.
- Create three distinct groups of search criteria. Groups have an AND relationship with each other.
- Add up to ten filter rows in each group. Filters can have an AND or OR relationship with each other.
- Each filter row pairs a field, an operator, and a value.
- Mark each row Include or Exclude to combine include and exclude criteria in a single query.
- Edit or delete a group directly from the advanced filters modal.
- Save, edit, or delete your filter combination. Anyone in your org can use a saved filter, but if you have the Role assignments feature enabled, only super admins or the filter creator can make changes to it.
Operators
| Operator | Definition |
|---|---|
Exactly match
|
Records where the field value set exactly equals the selection |
Contains
|
Records where the field contains the input text anywhere in its value |
Within the last
|
Records with a date field within the last N days from now |
More than
|
Records with a date field older than N days ago |
Before
|
Records with a date field strictly before the specified date |
After
|
Records with a date field strictly after the specified date |
Between
|
Records with a date field falling within the specified date range |