I have a report with a numeric field "days":
SELECT ...,
round((strftime('%s','now')-changetime)/86400) as "days",
...
but when I click the report column header to sort by that field it seems to
sort alphabetically (stringwise) rather than numerically. Any way to fix
that, i.e. to tell the report module that a column contains numeric data?
Also will the ticket query module that replaces reports be able to do things
like the above?
thanks,
-- Gary Oberbrunner
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
