MicroStrategy ONE

List Folder Properties statement

List the properties of a given folder.

Copy 
LIST [ALL] PROPERTIES FOR FOLDERfolder_nameINlocation_pathFOR PROJECTproject_name;

where:

  • folder_name is the name of the folder for which its properties are to be listed, of type string, between double quotes (" ").
  • location_path is the folder path where the folder is located, of type string, between double quotes (" ").
  • project_name is the name of the project that contains the folder, of type string, between double quotes (" ").

Example

Copy 
LIST ALL PROPERTIES FOR FOLDER "Sales Reports" 
 IN "\Public Objects" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

CHILDCOUNT: The number of items contained in the folder, returned as an integer.

CREATION_TIME: The date and time the folder was created, returned as a date/string.

DESCRIPTION: The description of the folder, returned as a string.

HIDDEN: Whether or not the folder is hidden, returned as a boolean value.

ID: The object ID of the folder, returned as a string.

LONG_DESCRIPTION: The long description of the folder, returned as a string.

MODIFICATION_TIME: The date and time the folder was last modified, returned as a date/string.

NAME: The name of the folder, returned as a string.

OWNER: The owner of the folder, returned as a string.