EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB206430 How to keep the sort order of the objects listed as Search result within an object prompt in MicroStrategy Web and Developer 9.4.1 and 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This document shows how to specify the order of the objects that appear in the prompt list in MicroStrategy Desktop and Web 9.4.1 and 10.x. This document provides steps and video information on how our current designed behavior looks like. There are two workarounds provided. 

SUMMARY:
This document shows how to specify the order of the objects that appear in the prompt list in Strategy Developer and Web 9.x. This document provides steps and video information on how our current designed behavior looks like. There are two workarounds provided. 
 
QUESTION:
Is it possible to control the order of the objects appears in Object Prompt list? It seems that the option to sort by different columns is available in the Search window where the Search result is displayed. For example, all metrics are searched and the result is sorted by modification Time:
 

ka02R000000kcSxQAI_0EM440000002CCL.jpeg

 
But when an object prompt is defined with this Search result, the list of metrics appears in alphabetic order. 
 

ka02R000000kcSxQAI_0EM440000002CCP.jpeg

 
ANSWER: 
While Search result can be displayed by different columns, it is not saved as a part of the Search object definition. When the Search object is closed and re-opened, the object list appears as sorted by "Name" field.
 
VIDEO:
A video with how the steps above can be seen in Strategy Architect can be seen blow:
 
 
WORKAROUND 1: 
Manually define the list of objects. The order appears as you specified.
 

ka02R000000kcSxQAI_0EM440000002CCJ.jpeg

 
WORKAROUND 2: 
Rename objects with numbers prior to the object names:

ka02R000000kcSxQAI_0EM440000002CC7.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

April 18, 2017

Last Updated:

April 18, 2017