Clarity: How to change sort order in portlet Life-cycle funnel?

Document ID : KB000024120
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How can I change the sort order applied to funnel diagram portlets, such as the Life Cycle Funnel?

 

Answer:

In portfolio management, the Life cycle funnel can be shown from "Analyze" tab. The information is always shown in alphabetical order.

Figure 1

 

The NSQL query behind the portlet contains the following SQL command which sorts them alphabetically:

 [...]    GROUP BY         CA.ODF_OBJECT_CODE, PROCESS_CODE, STAGE_CODE_CAPTION, STAGE_NUMBER, PORTFOLIO    _ID, SCENARIO_ID, COMPARE_TO_SCENARIO_ID, STATUS, ROLE_ID, BOOKING_STATUS_ID   [...]  

 

This is working as expected,and the NSQL query cannot be modified. We suggest to add a "number" in front to the text such us:

  1. Initation

  2. Planning

  3. Design

  4. Bid-Procurement

  5. Implementation

 

For example:

Figure 2