MicroStrategy ONE

List Security Filter Properties statement

Lists current values of properties of a security filter.

Copy 
LIST [ALL] PROPERTIESFOR SECURITY FILTER "security_filter_name"[FOLDER "location_path"]FORPROJECT "project_name";

where:

  • SECURITY FILTER "security_filter_name" is the name of the security filter for which properties are to be listed, of type string.

  • FOLDER "location_path" is the folder where the security filter is located in the project, of type string.

  • PROJECT "project_name" is the name of the project to which the security filter belongs, of type string.

Example

Copy 
LIST ALL PROPERTIES 
 FOR SECURITY FILTER "SecFilter1" OF PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

BOTTOM_ATTRIBUTE_LIST: A list of bottom range attributes associated with the security filter. Returned as a vector with type string.

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

EXPRESSION: The expression of the security filter, returned as a string.

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.

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

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

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

TOP_ATTRIBUTE_LIST: A list of top range attributes associated with the security filter. Returned as a vector with type string.

USER_GROUP_RESULTSET: A ResultSet containing information about the user groups associated with the security filter.

USER_RESULTSET: A ResultSet containing information about the users associated with the security filter.