InValuesLimit
- Last Updated: September 4, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Salesforce 6.0
- Documentation
Purpose
Determines the number of values in an IN clause subquery
to be materialized. If this value is exceeded, the driver processes the subquery as a JOIN
clause. You can use this property if your query exceeds the maximum SOQL length set by
Salesforce.
Valid Values
x
where:
- x
- is a positive integer that represents the number of values in an
INclause.
Behavior
If set to x, the driver limits the number of values in an IN
clause subquery to the specified value. If the number of values exceeds this limit then the
subquery is processed as a JOIN clause.
Data Source Method
setInValuesLimit
Default
200
Data Type
int