function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SuAkSuAk 

SQL behind the reports

I have  a report that I use in Salesforce and would like to know the SQL behind it .. Do we have any option for the same ?
Prateek Singh SengarPrateek Singh Sengar
Hi Sujatha,
It typically easy to guess the query behind the report. You need to see the filters and put them in the where clause. If its a join report you might want to use multiple queries.
SuAkSuAk
Hi - When I generate a report on Companies object, I see a coulmn for Source system but when I query in DB for Source system, I do not see any values for Source system(NULL is returned). I want to understand from where the values are being populated.

Thanks,
Sujatha

 
Prateek Singh SengarPrateek Singh Sengar
Can you share screenshot of the report, click on customize and provide the screenshot of the filters and columns.