List Of Values In The Search View Is Not Ordered Correctly
Last updated on JULY 10, 2018
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 Emp 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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms