Table of Contents

Search

ServiceNow Connector

ServiceNow Connector

Rules and guidelines for data filters

Rules and guidelines for data filters

Consider the following rules and guidelines when you apply data filters to filter ServiceNow objects:
  • When you configure a filter, the query options does not accept NULL values.
  • When you configure a filter condition, use
    Not Parameterized
    from the query options.
  • For NULL operator, ensure that the <Field name> appears before the <Table name> in the advanced filter condition.
  • Do not filter fields that are similar to <table name><Field name>!=null.
  • Do not filter fields that are similar to <dv_field name>.
  • Open and closed brackets () used in filter conditions are not supported by ServiceNow.
    You can instead specify the following operators, or use the formats supported by ServiceNow:
    • AND operator for applying AND in simple and complex filter queries.
    • OR operator for applying OR in simple queries
    • ORNewQuery operator for applying OR for complex queries
      For example,
      Category=Software AND Incident_State=7 ^NQ category=hardware AND Incident_state=1 OR Incident_state=2
      For more information about the formats supported by ServiceNow, see the ServiceNow documentation.
  • When you configure a filter to read from or write data to ServiceNow and a part of the filter query is not valid, ServiceNow returns rows using only the valid portion of the query and ignores the rest.
  • When you configure advanced filters, ensure that the filter condition contains only the field name, operator, and field value. You must remove any additional text that is appended to the filter condition.

0 COMMENTS

We’d like to hear from you!