Skip to content

Instantly share code, notes, and snippets.

@Harrisonbro
Created August 11, 2014 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Harrisonbro/2b10cf8723b6167e9a18 to your computer and use it in GitHub Desktop.
Save Harrisonbro/2b10cf8723b6167e9a18 to your computer and use it in GitHub Desktop.
Get Salesforce reports from report folder
public List<report> getDashboardReports()
{
// Get matching report folder ID
folder[] folders = [
SELECT
id,
name,
developername
FROM
folder
WHERE
name = 'My Dashboard Reports'
];
Id dashboardReportFolderId = (folders.isEmpty()) ? null : folders[0].id;
// Return reports from that folder
report[] dashboardReports = [
SELECT
id,
name,
description
FROM
report
WHERE
ownerid = :dashboardReportFolderId AND
ownerid != null
ORDER BY
name
];
return (dashboardReports.isEmpty() == null) ? null : dashboardReports;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment