MicroStrategy ONE

List Custom Group Properties statement

List all properties of a custom group in a project.

Copy 
LIST [ALL] PROPERTIES FOR CUSTOMGROUPcustomgroup_nameIN FOLDERlocation_pathFOR PROJECTproject_name;

where:

  • customgroup_name is the name of the custom group, of type string, between double quotes (" ").

  • location_path is the folder where the custom group resides, of type string, between double quotes (" ").

  • project_name is the name of the project, of type string, between double quotes (" ").

Example

Copy 
LIST ALL PROPERTIES FOR CUSTOMGROUP "Top 5 Contributors vs. All" IN FOLDER "\Public Objects\Custom Groups" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

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

CUSTOM_GROUP_ELEMENT_HEADER_DISPLAY_POSITION: The display position of the custom group element header, such as "Above Child Element". Returned as a string.

CUSTOM_GROUP_ELEMENT_NAME_RESULT_SET: A ResultSet containing a list of custom group elements and their related details.

  • CUSTOM_GROUP_BAND_NAME_RESULT_SET: A ResultSet containing a list of custom group band names.

  • CUSTOM_GROUP_ELEMENT_NAME: The name of the custom group element, returned as a string.

  • DISPLAY_OPTION: The display setting for the custom group element, such as "ShowAllAndExpand or

  • EXPRESSION: The expression for the custom group element, returned as a string.

  • OUTPUT_LEVEL_RESULT_SET: A ResultSet containing information about the custom group element output level.

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

ENABLE_HIERARCHICAL_DISPLAY: Whether or not hierarchies are displayed, returned as a boolean value.

ENABLE_SUBTOTAL_DISPLAY: Whether or not subtotals are displayed, returned as a boolean value.

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

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

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

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

NAME: Name of the custom group, returned as a string.

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