Advanced Filtering in a Schema Details Report

Advanced filtering of schema details can provide flexibility in the way that data is analyzed and reviewed, by allowing organizations to specify complex conditions and multiple criteria that must be met in order for data to be included or excluded from the analysis.

To apply advanced filters in the report, do the following:

1. View a Schema details report. For more information see View Access Details for a Database User.
2. Click Show Advanced SCIM Query Builder.
3. Use the provided filter builder and dropdowns to type in your filter(s). Advanced filtering uses System for Cross-Domain Identity Management (SCIM) syntax and supported operators include:
   • co: matches resources with an attribute that contains a given string
   • eq: matches resources with an attribute that is equal to a given value (not case sensitive)
   • eq_cs: matches resources with an attribute that is equal to a given value (case sensitive)
   • ew: matches resources with an attribute that ends with a given string
   • ge: matches resources with an attribute that is greater than or equal to a given value
   • gt: matches resources with an attribute that is greater than a given value
   • in: matches resources with an attribute that is equal to any of given values in list
   • le: matches resources with an attribute that is less than or equal to a given value
   • lt: matches resources with an attribute that is less than a given value
   • ne: matches resources with an attribute that is not equal to a given value
   • not_in : matches resources with an attribute that is not equal to any of given values in list
   • pr: matches resources with an attribute if it has a given value
   • sw: matches resources with an attribute that starts with a given string

   Operators can be grouped using parentheses to specify the order.

   Filters can also be combined using logical operators such as and and or.

   Note:

   If you have any basic filters currently applied they will appear in the query builder as well.
4. Click Apply.

To clear the query builder, click Clear. This will clear any basic filters applied as well.