1. Using Oracle Data Safe
  2. User Assessment
  3. Manage User Assessments
  4. Tips for Using the Filter Builder to Create Advanced Filters

Tips for Using the Filter Builder to Create Advanced Filters

  • Pressing the escape key while in advanced filtering mode will clear the whole query.
  • Pressing the space key will display the drop down with the list of available attributes or operators.
  • Pressing the space key after entering a value like tablename (employee_list) will enclose the string with quotes: ("employee_list")
  • Pressing enter will close the drop down listing the operators and attribute names.
  • If a value like Privilege type has spaces in it, typing space will enclose the first word within quotes, "Object" Privilege. You will have to move the cursor back to the enclosed string and continue typing the rest of the string value.
  • If you build a filter in advanced filtering that can't be displayed in basic filters, you can't switch back to basic filtering mode. For example, advanced filters with the or condition can't be displayed in basic filtering.
  • A custom report with basic filter can be updated with advanced filter and saved.

For more information about SCIM, see the protocol documentation at https://www.rfceditor.org/rfc/rfc7644.

For more information about filtering in SCIM, see the filtering section of the protocol documentation at https://www.rfc-editor.org/rfc/rfc7644#section-3.4.2.2.