We created a new query for a custom object in Salesforce. We are only returning 312 records back, when we should have around 2596 .
Our query limit is 1000. How can we tell why it's not pulling everything back? We've tested the same query with the Splunk Salesforce user and it's returning the correct amount of records. Does the input paginate correctly?
Is there any troubleshooting we can look at to tell us what query it is running against Salesforce, the raw results, and other information.
In addition, how does the query limit work? Does it just append a LIMIT onto the sql query, or does it also count against a sub-select?