MicroStrategy ONE

List Documents statement

List

Copy
LIST [ALL] DOCUMENTS [IN FOLDERlocation_path] 
 FOR PROJECTproject_name;

all documents in a selected location in a project.

Copy
LIST [ALL] DOCUMENTS [IN FOLDERlocation_path] 
 FOR PROJECTproject_name;

where:

  • location_path is the folder where the documents are located, of type string, between double quotes (" ")

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

Example

Copy
LIST ALL DOCUMENTS FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

FOLDER: The path to the document, returned as a string.

GUID: The GUID of the document, returned as a string.

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

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