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.