List Schedule Relations statement

Lists all of the available schedule relations.

LIST [ALL] SCHEDULERELATIONS [FOR (SCHEDULEschedule_name| (LOGIN | GROUP) login_or_group_name| REPORTreport_or_doc_nameINlocation_path)] IN PROJECTproject_name;

where:

• schedule_name is the name of the schedule for which schedule relations are to be listed, of type string, between double quotes (").
• login_or_group_name is the login name of the user/group for which schedule relations are to be listed, of type string, between double quotes (").
• report_or_doc_name is the name of the report/HTML document for which schedule relations are to be listed, of type string, between double quotes (").
• location_path is the folder path where the report/HTML document is located in the project, of type string, between double quotes (").
• project_name is the name of the project for which schedule relations are to be listed, of type string, between double quotes (").

This statement can only be executed in a Windows environment.

Examples

LIST ALL SCHEDULERELATIONS FOR SCHEDULE "All The Time" IN PROJECT "MicroStrategy Tutorial";

LIST ALL SCHEDULERELATIONS FOR USER "Calvin Rosie" IN PROJECT "MicroStrategy Tutorial";

LIST ALL SCHEDULERELATIONS FOR GROUP "Everyone" IN PROJECT "MicroStrategy Tutorial";

LIST ALL SCHEDULERELATIONS FOR REPORT "Revenue vs. Forecast" IN "\Public Objects\Reports" IN PROJECT "MicroStrategy Tutorial";

LIST ALL SCHEDULERELATIONS IN PROJECT "MicroStrategy Tutorial";

ResultSet Columns

CONTENT: The content of the schedule relation, returned as a string.

DOCUMENT_NAME: The name of the report/HTML document for which schedule relations are to be listed, returned as a string.

IS_GROUP: Whether the user/group associated with the schedule relation is a group, returned as a boolean value.

PATH: The path to the schedule relation, returned as a string.

PROJECT: The name of the project with which the schedule relation is associated, returned as a string.

SCHEDULE: The name of the schedule with which the schedule relation is associated, returned as a string.

SCHEDULER_RELATION: The name of the schedule relation, returned as a string.

USER_OR_GROUP_NAME: The user or group name with which the schedule relations are associated, returned as a string.