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
serge_gainsbourgserge_gainsbourg 

Ghost Data Appearing in Salesforce Reports

We have scheduled pulls from Salesforce for a few native objects.  To show staff which recrods are slated or pulling, we have reports and dashboards available that they can access.  We then pull the data using the data loader and SOQL queries that match the report filter criteria for each object.  One criterion was that the Contact record have a value in the Phone field.

 

However, the report for Contacts showed about 100 more records fitting the criteria than were pulled with the data loader.  We played around extensively with both the report and query wondering what might be the difference between the two.

 

What we found is that the Salesforce report was showing some Contacts has having a value in the Phone field (right there in the Phone column on the report) when there was no value on the Contact record itself (when we clicked through, the Phone field was blank).

 

Has anyone run into something like this?

 

 

AK1AK1

Yes I am seeing this too. Very Odd.