MicroStrategy ONE

List Security Filters statement

Lists the security filters granted to a user, to a group, or all in a given project.

Copy 
LIST [ALL] SECURITY FILTERS [(USER "login_name" | 
 GROUP "user_group_name")] [FOLDER "location_path"] FOR PROJECT "project_name";

where:

  • USER "login_name" is the user name for which security filters are to be listed, of type string.

  • GROUP "user_group_name" is the group name for which security filters are to be listed, of type string.

  • FOLDER "location_path" is the folder from which the security filters are to be listed, of type string.

  • PROJECT "project_name" is the name of the project for which security filters are to be listed, of type string.

Examples

Copy 
LIST 
 SECURITY FILTERS USER "Reba Snyderman" FOR PROJECT "MicroStrategy 
 Tutorial";
Copy 
LIST 
 ALL SECURITY FILTERS GROUP "Customers" FOR PROJECT "MicroStrategy 
 Tutorial";

 ResultSet Columns

FOLDER: The path to the security filter, returned as a string.

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

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