Comment on page
Filters
Harness the power of CIPPs filtering capabilities to effortlessly sift through data. Whether you're searching for a specific user or refining a larger dataset, this guide will walk you through the basic and advanced filtering techniques at your disposal.
There are two main filtering methods:
- Basic Filtering: Search for a keyword or phrase across all properties.
- Advanced Filtering: Apply specific conditions to filter data based on individual properties.
Simply type in the keyword or phrase you wish to search in the textbox.
To find all users with the name "Megan", type
Megan.
To utilize advanced filtering, start with the
Complex:
prefix. The general structure is:Complex: [PROPERTY] [OPERATOR] [VALUE]; ...
Operator | Description | Example Input |
---|---|---|
eq | Equals | Complex: department eq Marketing |
ne | Not equals | Complex: city ne Pittsburgh |
like | Contains the value | Complex: displayName like Megan |
notlike | Does not contain the value | Complex: userType notlike Guest |
gt | Greater than (for numerical values) | Complex: createdDateTime gt 2023-01-01 |
lt | Less than (for numerical values) | Complex: postalCode lt 20000 |
- PROPERTY: Indicate the property name you wish to filter on. You can find the possible properties by using the column selector button.
- OPERATOR: Use the operation you want to perform from the table above.
- VALUE: Specify the value you want to compare the property against.
You can combine multiple conditions with a semicolon (
;
).To find users located in Pittsburgh who are members, use:
Complex: city like Pittsburgh; userType eq Member
To identify users who are not enabled, are members, and have a
userPrincipalName
containing the word "diego", you can chain the filters as:Complex: accountEnabled eq false; userType eq Member; userPrincipalName like diego
Select pages support Graph Filtering, which allow you to directly use a Graph filter Query.
To utilize Graph filtering, start with the Graph
:
prefix. The general structure is:Graph: [GRAPH QUERY STATEMENT]
A Graph query can not be combined with other filters, and requires the query to be exactly as you would use it in the
$filter
parameter in a graph request. For example to filter on users with an assigned license, you enter:Graph: assignedLicenses/$count ne 0
Last modified 2mo ago