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
Nikki.ax79Nikki.ax79 

10k character limit on SOQL query

I just ran into this limit today, is it new?
-Nikki
ScotScot

Not saying it's good, but it's not new .. see http://forums.sforce.com/sforce/board/message?board.id=JAVA_development&message.id=1065

Scot
benjasikbenjasik
Can you give me an example of where you are using a SOQL query over 10k?

Thanks
Nikki.ax79Nikki.ax79
Benji,

I have a highly flexible application that can both read from and write to Salesforce through the API. An example would be: a person wants to add/update contacts, but doesn't want to create duplicates. They search for contacts that already exist in Salesforce using email and last Name. If they have 800 contacts to add/update the query can get long quickly. Select id, email, lastname, firstname where (email = 'blah@blah.com and lastName = 'blah') or (email = 'something@something.com' and lastName = 'something') or.....

It has forced me to limit the user to pushing 200 records at a time, which can take hours if their data set is large.

Is this what you needed?
Nikki
benjasikbenjasik
Thanks Nikki. We'll consider increasing this in the future. For now, I think your solution of doing more smaller batches sounds good.