MicroStrategy ONE
List Available Schedules for Report statement
List all schedules that can be used to subscribe to a report in a project.
Copy
LIST [ALL] AVAILABLE SCHEDULES FOR REPORT "report"
IN FOLDERlocation_path FOR PROJECTproject_name;
where:
-
report is the report for which schedules are being listed, of type string, between double quotes (" ")
-
location_path is the folder where the report is located, of type string, between double quotes (" ")
-
project_name is the name of the project, of type string, between double quotes (" ")
Example
Copy
LIST AVAILABLE SCHEDULES FOR REPORT "Revenue
vs. Profit" IN FOLDER "/Reports" FOR PROJECT "MicroStrategy
Tutorial";
ResultSet Columns
SCHEDULES_RESULT_SET: A ResultSet listing the schedules available for the report.
-
SCHEDULE: The name of a schedule available for the report, returned as a string.