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.