My Oracle Support Banner

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

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