List Of Values In The Search View Is Not Ordered Correctly

(Doc ID 2404585.1)

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.

Symptoms

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:

 

Changes

 

Cause

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