MicroStrategy ONE

List Shortcut Properties statement

Lists all the properties of a shortcut within a project.

Copy 
LIST [ALL] PROPERTIES FOR SHORTCUT (shortcut_name | GUID shortcut_guid) IN FOLDERlocation_pathFOR (FOLDER | CONSOLIDATION | DOCUMENT | FILTER | METRIC | PROMPT | REPORT | SEARCH | TEMPLATE | ATTRIBUTE | FACT | FUNCTION | HIERARCHY | TABLE | TRANSFORMATION | DRILLMAP | SECFILTER | AUTOSTYLE | BASEFORMULA | INTELLIGENTCUBE | DERIVEDELEMENT)FOR PROJECTproject_name;

where:

  • shortcut_name is the name of the shortcut whose properties are listed, of type string, between double quotes(" ")
  • shortcut_guid is the ID of the shortcut whose properties are listed, of type GUID.
  • 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 (" ").

Example

Copy 
LIST ALL PROPERTIES FOR SHORTCUT "Time" 
 IN FOLDER "\Public Objects" FOR HIERARCHY "Time (Browsing)" 
 FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

CREATION_TIME: The date and time the shortcut was created, returned as a date/string.

DESCRIPTION: The description of the shortcut, returned as a string.

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.

ID: The object ID of the shortcut, returned as a string.

MODIFICATION_TIME: The date and time the shortcut was last modified, returned as a date/string.

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

OWNER: The owner of the shortcut, returned as a string.

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

TARGET_PATH: The target of the shortcut, returned as a string.