Skip to Content

How To Sort List of Values in Prompts Screen

Hi All


I am explaining how to sort the LOV’s display in the prompts screen.


While running the report Cust ID LOV’s are not display in sort order, As a results user feel difficulty to select the values./wp-content/uploads/2014/06/1_472788.png

To apply  sort on Cust ID LOV’s -> double click the business layer under local project -> Select the parameters and lists of values tab -> Select the List of values based on custom SQL -> Specify the Name (Cust ID LOV)

/wp-content/uploads/2014/06/2_472789.png

Click on the Cust ID LOV and then click on the Edit SQL tab -> Specify the SQL in the editor -> Validate the expression and press OK

/wp-content/uploads/2014/06/3_472946.png

Sample Code

SELECT DISTINCT FIELD

FROM

TABLE

ORDER BY 1

Click on the Preview tab and check the results. Lov’s are displaying in sort order or not.

/wp-content/uploads/2014/06/4_472955.png

Once the LOV’s are display sort order -> Select the Business layer and click on the field: Cust ID –> Click on the advanced -> Select a list of values button, will get pop-up showing all the Custom SQL list of values-> select the Cust ID LOV and press OK.

/wp-content/uploads/2014/06/6_472954.png

Save the Business layer and export the universe to repository and then refresh the report and check the LOV’s.


Hope this helpful


Thanks

Sreeni


Be the first to leave a comment
You must be Logged on to comment or reply to a post.