id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 7764 Error when sorting report's result hanka 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 }}} " defect closed normal 0.12.1 report system minor fixed