How To Do It In Salesforce

Concepts or coding lessons of Salesforce that you can implement easily

How To Fetch All Private Reports Of All Users In Salesforce ?

Sometimes we have to Fetch All Private Reports Of All Users In Salesforce.


 We can see each user private reports after logged in as a feature.

 But its time-consuming.

 Here is Simple and Easy Solution to access All Private Reports Of All Users In Salesforce:

 SOQL Query:

 SELECT Id, Name, Owner.Name FROM Report USING SCOPE allPrivate

 Note: This functionality is available only for use on the Dashboards and Reports objects. It is not currently supported for use with queries against the DashboardComponent object.

 Features required for this functionality:

 If the following features are not enabled, you'll receive an error titled INVALID_QUERY_SCOPE. 
  1. Enable Reports & Dashboard Folder Sharing for the organization (Entire Organization)
  2. Expose the "Manage All Private Reports and Dashboards" User Perm (Entire Organization) NOTE: If this feature is not available, please contact Salesforce Support to have it enabled.
  3. Manage All Private Reports and Dashboards (For the profile of the user performing the search:)

Want to Fetch All Private Reports Of Particular Users easily then check post:

How To Fetch All Private Reports Of Particular Users In Salesforce?

Latest Salesforce Interview Questions and Answers:

More Salesforce Blogs:

Check out Salesforce Daily Limit Only in 5 Simplest Steps
Learning Pagination In Salesforce Is Not Difficult At All ! You Just Need 3 Easy Steps
How To Learn Get Field Values From Visualforce Page To Apex Class Controller Without Losing Your Mind
Main Difference Between ISBLANK And ISNULL in Salesforce
How To Get Total Amount Of Records Processed In Batch Job In 10 Minutes And Still Look Your Best 
Export VisualForce Data into Excel Sheet in 3 Easiest Steps
7 Easy Steps to Generate Apex Class From WSDL In Salesforce
Simplest Way To Find Number of Days Between Two Dates in Salesforce
3 Easy Steps To Send Emails With Attachment From Your Apex Class In Salesforce
How Insert Comma In Formula Fields Can Help You Improve Your Productivity
Simple Guidance For You In Access Of Subquery Field Value Using Apex - Upwards Traversal.
Access Subquery Field Value Using Apex in 2 Easy Steps- Downwards Traversal

How Learning Enable Inline Editing In Visual Force Pages Could Save Your Money And Time



Enjoy! If you have any questions, comments etc. please feel free to let me know. As always, please feel free to get in touch me as I would be more than happy to assist you with any of your Salesforce development needs.
1 comment:
Subscribe to: Posts (Atom)