List Of Values In The Search View Is Not Ordered Correctly
(Doc ID 2404585.1)
Last updated on FEBRUARY 26, 2020
Applies to:BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.
On : 12.2.x version.
The sort order of the List of Values (LOV) after clicking in LOV parameter Search option is not correct based on the SQL defined in the Data Model
The issue can be reproduced at will with the following steps:
1. Login to Xmlpserver (BIP) -> new -> create a New Data Model
In the Data Sets, use Employee List (employees table) for instance.
In the Data Model -> List of Values add:
deptListid -> SQL Query:
In the Data Model -> Parameters:
dept -> Type: Menu -> List of Values: deptListid
emp-> Type: Menu -> List of Values: empLisdt
2. In the Data Model, click "View Data"
3. Click "Search"
4. In the Search Applet it shows:
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