Skip to main content

Case sensitivity

The following are case-insensitive:

  • Filter types except for system attribute names, profile attribute names, custom relationship names, custom attribute names, and UDP names used as filter types. For example, "text = 'Customer'" is equivalent to "TEXT = 'Customer'".
  • Operators. For example, = all is equivalent to = ALL, before is equivalent to BEFORE, or is equivalent to OR, etc.
  • Search properties used in the WITHIN clause of the text or semantic_search_text filters.
  • Keywords used as filter values, such as ME, TODAY and YESTERDAY.

The following are case-sensitive:

  • The FROM clause. For example, /Published is not equivalent to /published.
  • System attribute names, profile attribute names, custom attribute names, custom relationship names, and UDP names used in the SELECT list, ORDER BY fields, or as filter types in the WHERE clause. For example, "Security level" is not equivalent to "security level".
  • Filter values except the keywords such as ME, TODAY and YESTERDAY.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!