Learn how to query for private reports and dashboards as a Salesforce administrator.
Report Query
SELECT Id, Name, CreatedBy.Name FROM Report USING SCOPE allPrivate
Report Grouping Query
SELECT CreatedBy.Name, COUNT(Id) reportCount FROM Report USING SCOPE allPrivate GROUP BY CreatedBy.Name ORDER BY COUNT(Id) DESC
Dashboard Query
SELECT Id FROM Dashboard USING SCOPE allPrivate
Lighning Inspector Extension Used to Write Query in the Video
Chrome: chromewebstore...
Firefox: addons.mozilla...
Edge: microsoftedge....
Report sObject Reference
developer.sale...
Dashboard sObject Reference
developer.sale...
Join the Salesforce Saturday Email for weekly Salesforce and Career tips (Free):
www.nickfrates...
Get the 10 Ways to Boost Your Salesforce Career Guide (Free):
www.nickfrates...
Check out the Salesforce Flows Complete Guide:
www.nickfrates...
#salesforce #salesforcetutorial #salesforceforbeginners #salesforceadmin #salesforcetutorials #salesforcereports #salesforcelightning #soql
15 окт 2024
