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: queryRecord
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.
Thank you