MicroStrategy ONE
List Searches statement
Lists all the search objects in a project, or in a folder in a project.
Copy
LIST [ALL] SEARCHES [IN FOLDER "location_path"] FOR PROJECT "project_name";
where:
-
location_path is the path in the project
-
project_nameis the project for which search objects are to be listed
Examples
Copy
LIST SEARCHES FOR PROJECT "MicroStrategy Tutorial";
Copy
LIST ALL SEARCHES IN FOLDER "Public Objects\Searches" FOR PROJECT "DevelopmentAlpha";
ResultSet Columns
FOLDER: The path to the search object, returned as a string.
NAME: The name of the search object, returned as a string.