MicroStrategy ONE
List Custom Groups statement
List all custom groups in a folder of a project or in a project.
Copy
LIST [ALL] CUSTOM GROUPS [IN FOLDERlocation_path] FOR PROJECTproject_name;
where:
-
location_path is the folder where the custom groups are going to be listed, of type string, between double quotes (" ").
-
project_name is the name of the project, of type string, between double quotes (" ").
Example
Copy
LIST ALL CUSTOM GROUPS IN FOLDER "\Public Objects\Custom Groups\" FOR PROJECT "MicroStrategy Tutorial";
ResultSets Column
-
HIDDEN: Whether the custom group is hidden, returned as a boolean value.
-
NAME: Name of the custom group, returned as a string.
-
PATH: Folder path of the custom group, returned as a string.