Getting rid of the LOV timestamp

One of the famous problems in Designer is getting rid of the timestamp LOV and sorting the date LOV according to the date column.

Here is the step by step procees in order to achieve that in Oracle:

1.first we have the date object in the universe named :Time Key

2.Inside the object properties we can see the date LOV time stamp:

3.Now we will create an object that will be used inside the object's LOV,later on we re-map the lov of the date object to this object's LOV:

this object contain the function to_char in order to format the date object.

4.Inside the time key object properties we will re-map the LOV to the "No time stamp LOV " object and sort it from Z to A

 

5.Now we will get inside the object LOV and esit it's SQL to:

SELECT

to_char(TIME.TIME_KEY,'dd/mm/yyyy')

FROM

TIME

ORDER BY TIME.TIME_KEY



 

 

 

 

 

 

 

 

 

 

the result is :

 

make sure that you thick the "do not genertae" button  and the "export with universe" property of the LOV.