Supported operators

This topic describes different types of supported operators in the Search page.

Supported operators

The following table contains a list of the supported operators in the Search page.
Operator Type
Begins with String operator
Contains String operator
Ends with String operator
Equals Relational operator
Empty Generic for multiple operators
Does not begin with String operator
Does not contain String operator
Does not end with String operator
Does not equal Relational operator
Is not empty Generic for multiple operators
In Membership operator
Not in Membership operator
Length less than String length operator
Length greater than String length operator
Matches String operator
Does not match String operator
Begins with match case String operator
Ends with match case String operator
Contains match case String operator
Greater than Relational operator
Greater than or equal to Relational operator
Less than Relational operator
Less than or equal to Relational operator
Is one of Identity operator
Is not one of Identity operator
Does not begin with match case String operator
Does not end with match case String operator
Does not contain with match case String operator
Equals match case String operator
Not equals with match case String operator
Is not greater than Relational operator
Is not greater than or equal to Relational operator
Is not less than Relational operator
Is not less than or equal to Relational operator
Note: For best performance of the In and Not In search operator, it is recommended to use category mapping. If the entire Catalog is selected, the performance of the search might get impacted.

Attributes and supported operators mapping

Following table describes attributes and supported operators mapping.
Attributes Operator - In
Scope - All		 Operator - Not in
Scope - All		 Operator - Length greater than Operator - Length less than
Binary ❌ ❌ ❌ ❌
Currency ✓ ✓ ❌ ❌
Date ✓ ✓ ❌ ❌
Flag ✓ ✓ ❌ ❌
Image ❌ ❌ ❌ ❌
Image url ✓ ✓ ❌ ❌
Integer ✓ ✓ ❌ ❌
Lookup ✓ ✓ ❌ ❌
Number ✓ ✓ ❌ ❌
NumberEnum ✓ ✓ ❌ ❌
Password ❌ ❌ ❌ ❌
Relationship ✓ ✓ ❌ ❌
Rich Text ❌ ❌ ❌ ❌
Sequence ❌ ❌ ❌ ❌
String ✓ ✓ ❌ ✓
String Enum ✓ ✓ ❌ ✓
Thumbnail ❌ ❌ ❌ ❌
Thumbnail url ✓ ✓ ❌ ❌
Timezone ✓ ✓ ❌ ❌
URL ✓ ✓ ❌ ❌

Known limitations

Following is list of known limitations.
  • Membership operators support comma-separated list of values.
  • String length operators only work support String and String enumeration types attributes.
  • Lookup table and Relationship attributes support following format.
    Lookup table attribute
    LKPNAME>>PK>>DISPATTRIB
    LKPNAME>>PK
    Relationship attribute
    CTG>>PK>>DA
    CTG>>PK

    When you create a search, LKPNAME and CTG names are mandatory in the displayformat else the primary key, or the display attribute cannot be fetched. The primary key is unique to its container and the display attribute is never unique and hence search might fail.

  • Sequence attribute is not supported in a multi-occurrence format.
  • Search for the Sequence attribute with empty operator is not supported.
  • The password is in the encrypted form, and hence cannot be searched.
  • You cannot search images, binaries, or thumbnail files.
  • Time zone attributes containing "," (comma) are not supported by the In or Not In operators.
  • Rich text attribute - To search <> character, you need to search by using L&lt;gt character (excluding the double quotation marks).
  • URL attribute supports valid URL. The GIF and image type URL are not supported.