Hi I have a problem to in List of values.
If I taken an object with to_char(date,‘Month’)
I am getting the values in
April
August
December
Febravary
in alphabatical order,
But I want it to be in Months order like January,Febravery,March.
Thats the default sort order that can be changed by Modifying the LOV SQL… Edit the LOV and in the Query Panel that opens up click SQL and put this and then check “Do Not Generate SQL before running” and then close… Now display the LOV you should be getting the desired output…
SELECT
MONTH
FROM
(
SELECT
DISTINCT
TO_CHAR(DATE,'MM'),
TO_CHAR(DATE,'Month') "MONTH"
FROM
TABLENAME
ORDER BY
TO_CHAR(DATE,'MM')
)
If you have Calendar Table kinda stuff then you can simply pick up the Month Number and Month Name and do the sort there instead of doing TO_CHAR() stuff…
I know about this “export to universe”… But it still doesn’t work the way intended when I alter my Free hand Sql, only in WEBI, FC works correct. Some sort of bug. For sure!