function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ghjkghjk 

IN Clause query

Is there a substitute for IN clause in SOQL... I am trying to query the same field for multiple values and would like to use the same to minimize ntwk traffic... Also what is the max size of the SOQL query that can be passed to SFDC.. Is there a limit for the same...

benjasikbenjasik
value = x or value = y or value = z

10k characters is the limit. We'll eventually add an IN statement so you can do this and have more values in your statement.
sanjusanju

hi

SQOL Qurey length can be of max.  10,000 characters. More than it will cause MALFORMED QUERY exception.