MicroStrategy ONE

List Filters statement

Lists all the filters for a given project.

Copy 
LIST [ALL] FILTERS [IN [FOLDER] location_path] [FOR OWNER login_name] FOR PROJECT project_name;

where:

  • location_path is the folder path for which all the filters will be listed, of type string, between double quotes (" ").

  • login_name is the login name of the user who is the owner of the listed filters, of type string, between double quotes (" ").

  • project_name is the name of the project for which all the filters will be listed, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Example

Copy 
LIST 
 ALL FILTERS IN "\Public Objects\Filters" FOR PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

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

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

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