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?
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