MicroStrategy ONE
List Shortcuts statement
Lists all the existing shortcuts within a project.
LIST [ALL] SHORTCUTS [IN FOLDERlocation_path] FOR PROJECTproject_name;
where:
-
location_path is the folder where the shortcut resides, of type string, between double quotes (" ").
-
project_name is the name of the project, of type string, between double quotes (" ").
Examples
LIST ALL SHORTCUTS FOR PROJECT "MicroStrategy
Tutorial";
LIST ALL SHORTCUTS IN FOLDER "\Public Objects\Reports FOR PROJECT MicroStrategy
Tutorial;
ResultSet Columns
DSS_OBJECT_TYPE: The type of the object the shortcut points to, returned as an integer:
-
256: Filter
-
257: Custom Group
-
512: Template
-
768: Grid Report
-
769: Graph Report
-
770: SQL Report
-
771: Text Report
-
772: Data Mart Report
-
773: Base Report
-
774: Grid Graph Report
-
775: Non Interactive Report
-
776: Intelligent Cube
-
1024: Metric
-
1025: Subtotal
-
1026: Subtotal
-
1027: Predictive Metric
-
1028: Training metric
-
1536: AutoStyle
-
1792: Base Formula
-
2048: Folder
-
2560: Prompt
-
2561: Boolean prompt
-
2562: Long number prompt
-
2563: Text prompt
-
2564: Numeric prompt
-
2565: Date prompt
-
2566: Object prompt
-
2567: Elements prompt
-
2568: Expression prompt
-
2569: Expression draft prompt
-
2571: Big Decimal Prompt
-
2816: Function
-
3072: Attribute
-
3073: Role Attribute
-
3074: Transformation Attribute
-
3075: Abstract Attribute
-
3328: Fact
-
3584: System Hierarchy
-
3585: Hierarchy
-
3586: Ordered User Hierarchy
-
3587: Hierarchy03840: Logical Table
-
3841: Metadata Partition Mapping
-
3842: Warehouse Partition Mapping
-
4352: Fact Group
-
4864: Resolution
-
5376: Attribute form
-
5377: Form
-
5378: Form
-
5632: Schema
-
6144: Catalog
-
6400: Catalog definition
-
6656: Column
-
7168: Property Set
-
7424: Database Instance
-
7680: Database login
-
7936: Database connection
-
8192: Project
-
8448: Server Definition
-
8704: User
-
8705: User Group
-
9216: Configuration
-
9472: Request
-
9984: Search
-
10240: Search folder
-
10752: Function Package Definition
-
11008: Role
-
11009: Transformation
-
11264: Security role
-
12032: Consolidation
-
12288: Consolidation Element
-
12544: Event
-
12800: Schedule
-
13056: Schedule
-
13312: Link
-
13568: Warehouse Table
-
13569: Partition table
-
13824: Table source
-
14080: HTML Document
-
14081: Document
-
14336: Drill Map
-
14592: DBMS
-
14848: Security Filter
HIDDEN: Whether or not the shortcut is hidden, returned as a boolean value.
NAME: The name of the shortcut, returned as an integer/string.
PATH: The path to the shortcut, returned as an integer/string.