MicroStrategy ONE

List Available Schedules for Document statement

List all schedules that can be used to subscribe to a document in a project.

Copy
LIST [ALL] AVAILABLE SCHEDULES FOR DOCUMENT "document" 
 IN FOLDERlocation_path FOR PROJECTproject_name;

where:

  • document is the document for which schedules are being listed, of type string, between double quotes (" ")

  • location_path is the folder where the document 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 DOCUMENT "Profit Margin" IN FOLDER "/Documents" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

SCHEDULES_RESULT_SET: A ResultSet listing the schedules available for the document.

SCHEDULE: The name of a schedule available for the document, returned as a string.