Error when sorting report's result
|Reported by:||hanka||Owned by:||Remy Blank|
Im' using Trac 0.11.1 with postgres database. I've created SQL report:
select id as "Cool Ticket", owner, milestone from ticket where id<10
I receive error when trying to sort results by column Cool Ticket.
Report execution failed: syntax error at or near "Ticket" LINE 1: ...e from ticket where id<10 ) AS tab ORDER BY Cool Ticket ASC... ^
In log file of Trac I have found that following SQL is executed:
2008-10-29 15:40:03,775 Trac[report] DEBUG: Query SQL: SELECT * FROM ( select id as "Cool Ticket", owner, milestone from ticket where id<10 ) AS tab ORDER B Y Cool Ticket ASC LIMIT 100 OFFSET 0