Hi All, I want to create a report to display all states a ticket has gone through.
Ex: Ticket 1 | new -> assigned -> closed -> reopened -> assigned I tried using following query to generate the result: select ticket,group_concat(newvalue) from ticket_change where field='status' It is working fine if directly executed on db, but when I added this in Trac reports, its showing "no such function: group_concat" error. Is there any other way to get the all states of a ticket? Thanks in advance. -Sneha --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---