Find the location/folder of a report programmatically

apexreporting

Been spending a long time trying to get all the info about a report programmatically using apex. One place I'm stuck at is how to get the folder name where the report is located in, and also its permissions, which means what role do you need in order to access this report. Take a look at this image for example.

Basically I just need to get the name "Folder for Testing", since that is where my report is located in.

I've tried using several methods from metadata api, reportResults, reportExtendedMetadata, but still no luck. I thought I would be able to do it using a SOQL query, but I'm still working on that. Any help is much appreciated.

Thanks.

Best Answer

The Report object has a FolderName field that should contain what you are looking for. As for how to run the query, I personally would just run it through the Developer Console (it has a Query Editor tab). You can add fields you care about to your SELECT clause.

SELECT FolderName FROM Report WHERE DeveloperName = 'My_Report'

Related Solutions

[SalesForce] How to use the API to get a list of reports in the Unfiled Public Report folder

You seem to have answered your own question here.

Any report in the 'Unfiled Public Reports' folder will have an OwnerId of your OrgId. You should be able to reference your OrgId programmatically when you query for it, something like:

[SELECT Id,Name from Report WHERE OwnerID = :UserInfo.getOrganizationId()];

[SalesForce] How to find the folder of a salesforce report

The Report object does not have a FolderId field like Dashboard, Document and EmailTemplate objects. But as you can see from this their does exist a child relationship between Folder and Report, which is in fact determined by the OwnerId of the Report.

Thus once you know the folder Id you can query for reports that are contained within it.

SELECT Id, DeveloperName,Name,Type FROM Folder 
  WHERE Name = 'My Test Folder' And
              Type = 'Report'

Then query by OwernId with the Folder Id returned e.g.

SELECT Description,DeveloperName FROM Report WHERE OwnerId = '00lG0000000TwG5IAK'

enter image description here

Best Answer

Related Solutions

[SalesForce] How to use the API to get a list of reports in the Unfiled Public Report folder

[SalesForce] How to find the folder of a salesforce report

Related Topic