Question:

What are the supported WHERE clauses for the queryRecord CLM API call?

Answer:

The supported where clauses are as shown below:

• where - string for the where clause
  • Supported clauses: 
    • WHERE (this means the word where is included)
    • >
    • <
    • =
    • <>
    • AND
    • OR
    • ( )
    • <=
    • >=
    • IN
      • When passing in an array as part of a where clause, it should be in curly braces.
    • BETWEEN
      • When passing in an array as part of a where clause, it should be in curly braces.
    • LIKE
  • Not supported: 
    • Nested WHERE clause
    • GROUP BY
    • JOIN
    • ON
    • IS NULL
    • IS NOT NULL
    • ORDER BY
    • DESC
    • ASC
    • LIMIT

Related Documentation:

Veeva CRM Developer Documentation: Integrating Approved Email with CLM