You need to sign in to do that
Don't have an account?
Ken_Koellner
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