You need to sign in to do that
Don't have an account?
chisholmd
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
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
Cheers
Dave