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
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.