function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
chisholmdchisholmd 

Query not returning all items

I run replication to my SQL server and at least one of my queries is not pulling all the rows.

This query should pull all OpportunityLineItem's shouldn't it?

select id,pubpoint__c,pp_type__c,opportunityID,pricebookentryid,productid,description,Daily_reports_email__c,serviceDate from opportunitylineitem

I havn't had a problem until a few days ago and now I can see that there are line items in salesforce that are not showing up in SQL. Many are, many are not.

Any ideas?

Dave
SuperfellSuperfell
are you calling queryMore to get all the results ?
chisholmdchisholmd
Rats you beat me to it :) Yes I just realized that I was only pulling 2000 records and I am updating my code to use queryMore.

Cheers
Dave