I have set a sort order column on one of A VARCHAR field, but the functionality is not working. The sorting is enabled in the table view and when I sort by the said column it still sorts based on the VARCHAR values of the column instead of the other INT column I want to sort by. The logical SQL and physical query never even includes the column to sort. Are there any exceptions for the 'Sort Order Column' setting? Is there a config setting or data connections setting that I need to check to make this work?
Edited by: VNC on Oct 3, 2011 9:08 AM
can you give me more detailes like some sample column data like below kind
Like Ex: varchar month column it sould display based on month id
month : Fev-2011,Dec-2011,jan-2011 and month id 1 to 12
set your month id as sort order column of month name.
double click month name ->In general tab set the sort order column as month id
FYI...see the sample link
i hope helped you
Edited by: Devarasu on Oct 4, 2011 12:39 AM
Thanks for the response. I have a Usage column in Secs that I'm converting into USAGE(HH:MM:SS) format using a formula and displaying as text. so when the user clicks on the HH:MM:SS column I want to use the Seconds value for sorting. I have set the sort order column on the calculated USAGE(HH:MM:SS) column to Usage field that is in secs. But when I sort the column it still sorts the values treating then as text. eg: 125:34:00 is after 2:30:00
I have to use following formula as there is aggregation needed:
CAST ( CAST ( TRUNCATE("Usage and Revenue"."Usage Facts"."Usage - Charge" / 3600, 0) AS INTEGER ) AS VARCHAR ( 12 )) || ':' || RIGHT('00' || CAST ( CAST ( TRUNCATE( MOD("Usage and Revenue"."Usage Facts"."Usage - Charge", 3600) / 60, 0) AS INTEGER ) AS VARCHAR ( 2 )), 2) || ':' || RIGHT('00' || CAST ( CAST ( MOD( MOD("Usage and Revenue"."Usage Facts"."Usage - Charge", 3600), 60) AS INTEGER ) AS VARCHAR ( 2 )), 2)