My Oracle Support Banner

Unifier Data View Output Is Not Sorting According To the Sort Defined In the SQL Definition (Doc ID 2567766.1)

Last updated on AUGUST 01, 2019

Applies to:

Primavera Unifier Cloud Service - Version N/A and later
Primavera Unifier - Version 9.7 and later
Information in this document applies to any platform.

Symptoms

On Unifier : Any Version

ACTUAL BEHAVIOR
---------------
Unifier Data View - the outputted Data for the Data View is not sorted in the order that is defined in the SQL Definition.
 
EXPECTED BEHAVIOR
-----------------------
Unifier Data View - the output should be sorted according to the order that is defined in the SQL Definition.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Sign into Unifier and in Admin mode navigate to: Company Workspace > Data Structure Setup > Data Views
  2. Open one Data View and notice the sort that is defined in the SQL Definition
  3. Close the Item and click on the Data button in the toolbar above the log
  4. Notice that the resulting output is not sorted according to the order that is defined in the SQL Definition, instead it is sorted by the first column in descending order

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, data is not correctly sorted in the result window.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.