List of values

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.

So can we define the object List of values Like.

thanks


Bharath (BOB member since 2004-06-12)

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…


Sridharan :india: (BOB member since 2002-11-08)

I noticed that changing the SQL in your LOV will not always work in webi, keep that in mind!

Maybe you can add an extra column in your LOV listing the monthnrs and sort on them.


jobjoris :netherlands: (BOB member since 2004-06-30)

It should work as long as you Export the LOV with the Universe… There is a check box that needs to be checked…


Sridharan :india: (BOB member since 2002-11-08)

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!


jobjoris :netherlands: (BOB member since 2004-06-30)

Jobjoris, which version of WebI are you using?


Andreas :de: (BOB member since 2002-06-20)

6.1b… Not very fond of it…


jobjoris :netherlands: (BOB member since 2004-06-30)