+ Start a Discussion

SOQL retrieve - limit to number of id's?

Hi. What is the limit to number of id's in the id list when Retrieve is called?



When using binding.query(string queryString) i.e. (API calls)

The query response object contains up to 500 rows of data by default. If the query results exceed 500 rows, then the client application uses the queryMore() call and a server-side cursor to retrieve additional rows in 500-row chunks. You can increase the default size up to 2,000 in the QueryOptions header, as described in Changing the Batch Size in Queries (http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_changing_batch_size.htm#topic-title).

Queries that take longer than two minutes to process will be timed out. 

Reference: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=Content/sforce_api_calls_soql.htm 

Other then this ,

Total number of records retrieved by SOQL queries in Anonymous Block,Visualforce Controller, or WSDL Method = 10,000^8 

Total number of records retrieved by a single SOSL query in Anonymous Block,Visualforce Controller, or WSDL Method = 200^8

Total number of elements in a single List = 1,000^3





Thanks for the reply. However, I was asking not what the limit of results was, but rather how many unique Id's I can have in my retrieve list.


eg. retrieve(id1, id2, id3, ..., id?)

Thanks! That's lower than I thought, what about the IN clause?