+ Start a Discussion
Farhad KeywanFarhad Keywan 

Problem in SOQL Result


In webservice i am taking data from server and for this i am using soql  but Soql is returning only 250 records.

Is this a new limitation of SOQL?
and  what is the workaround for such a problem ?

Most likely your batchSize is set to 250.

Make sure you have proper batchSize, and use queryMore() method to get all data

Documentation on the batchSize: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=Content/sforce_api_calls_soql_changing_batch_size.htm#topic-title


Please try to reduce the number of fields that you are querying from SOQL.


Thanks Shamil


It really works