How to locate dashboards and reports hidden in personal folders?
|Knowledge Article Number||000232625|
|Description||With the Spring '16 release a new feature was added to permit the location of Reports and Dashboards that have been saved into a user's "My Personal Folder." To utilize the functionality, the below must be true.
These features must be enabled for your organization:
This feature must be enabled on the profile of the user performing the search:
Please note that 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.
|Resolution||To utilize this feature, please include the below line within your SOQL query via API version 36 or higher.
USING SCOPE allPrivate
SELECT Id,Title FROM Dashboard WHERE Type != 'SpecifiedUser' (this query returns Dynamic Dashboards that are not in private folders)
SELECT Id,Title FROM Dashboard USING SCOPE allPrivate WHERE Type != 'SpecifiedUser' (this query returns Dynamic Dashboards that are in private folders)
Note: When using Workbench, make sure to select Include for the "Deleted and archived records" to show Reports/Dashboards in the Recycle Bin