MicroStrategy ONE

List Filter Properties statement

Lists the properties for an existing filter within a project.

Copy 
LIST [ALL] PROPERTIES FOR FILTERfilter_nameIN [FOLDER]location_pathFROM PROJECTproject_name;

where:

  • filter_name is the name of the filter for which the properties will be listed, of type string, between double quotes (" ").

  • location_path is the folder path where the filter is located, of type string, between double quotes (" ").

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

This statement can only be executed in a Windows environment.

Example

Copy 
LIST 
 ALL PROPERTIES FOR FILTER "East Region" IN FOLDER "\Public 
 Objects\Filters" FROM PROJECT "MicroStrategy Tutorial";

ResultSet Columns

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

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

EXPRESSION: The filter expression, returned as a string.

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

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

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

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

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

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