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.