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
-
Supported clauses:
Related Documentation:
Veeva CRM Developer Documentation: Integrating Approved Email with CLM