Hi there! I am using trac 0.11b2 w/mysql. Because almost all data is a text field, including custom fields, sorting is alphanumeric rather than numeric.
On reports, that's easily resolved by doing something like ORDER BY c.value +0, which turns it into a number and does things up pretty. However, using TracQuery the same trick doesn't work. In fact, any expression that involves modifying the data turns off any sort of sorting: [[TicketQuery(iteration=2,order=ipriority+0)]] Has anyone encountered this? Any ideas? Cheers, Kate --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
