+ Start a Discussion
Vijay RautVijay Raut 

Problem in Query and QueryMore logic

Hi,

As per SFDC Docs, Query call in Scontrol retrives 200 records. If we are going to retrive more than 200 records then querymore function is used.

I am using same query and queryMore using done flag.

But in my case, query call retrives more than 200 records and as I am updating those retrived records, update call has limit of 200 records in one call (Hence getting exception in SControl).

So is there any change in  query and query more call behavior or i am missing some thing?

Thanks
V. R.
cheenathcheenath
If there are more than 200 records to update, then you must split them
into batch of 200.

I am not aware of any change in query/queryMore.



Vijay RautVijay Raut

Hi Cheenath,

Thanks for your reply. I had sorted out that problem.

I was missing to set the batchSize. Default value of BatchSize was 200 in earlier versions. But now its default value is 500.

Hence in my scontrol, i have set it to the 200, and it works for me.

Thanks

V.R.