Sorting multiple columns in table widgets

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Sorting multiple columns in table widgets does not work. When the table widget is in edit mode (Configure view), the sorting is fine. When we are in display mode, the second column sorting takes precedence

STEPS TO REPRODUCE:

1. In MUX > Go to the Tasks Workspace
2. Sort the data by the Investment column first and set the Tasks name as second sorting column
3. The data is properly sorted by the Investment column first and Task name second
4. Create a project in MUX called "Hello" and create two Change Requests on the project: "Hello Change Open", "Hello Change Closed"
5. Create a project in MUX called "Bye" and create two Change Requests on the project: "Bye Change Open", "Bye Change Closed"
6. In MUX > Go to Administration > Blueprints and create a copy of the Standard Investment Hierarchy blueprint
7. Add a New Canvas module to the blueprint
8. In MUX > Go to Hierarchies workspace and create a Hierarchy
9. Associate it to the blueprint we created with the canvas module
10. Import both projects we created "Hello" and "Bye"
11. Go to the New Canvas module and add a Table Widget where the target object is the Change object
12. Go to the Configure wheel and set the Investment column as first sorting column and Status as second sorting column
13. Data is sorted correctly
14. Accept changes and exit the Widget Configure view 
15. Look at the data sorting

Expected Results: Sort column order to be respected and data to be ordered by Investment Name first and Status second
Actual Results: Data is ordered by the second sorting column being Status 

Environment

Clarity 16.2.X, 16.3.X

Cause

This is caused by DE174301

Resolution

This is fixed in Clarity 16.4.0