You need to sign in to do that
Don't have an account?

SOQL IN clause limit when referencing list or set variable
Is there any limit to the number of entries in a set or list that can be used in an IN clause in SOQL?
List<Id>myIdList = .... List<OpportunityLineItem>oliList = [select id, opportunityId, quantity from OpportunityLineItem where id in :myIdList];
Is there anythg that would prevent myIdList having 100, or 1000, or 5000 entries and still working with the SOQL query?
I reckon the maximum size of a collection would be the only restriction - 10K ?
Not sure, but I believe it would be limited to max size of SOQL query that is 10,000 characters.
Hi ken,
Did you figure it out? any documentaion around this limitaion?
Thanks,
Lakhan