On Jun 23, 1:58 am, Sneha <[email protected]> wrote: > 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
hmm, I would think you could do this with a custom sql report, on the ticket_change table. newvalue where ticket=N and field=status that's not the actual sql, but those are the tables and field names. where N is the ticket # you are inquiring about. now, you'd need some kind of concatenation or something if you wanted something like a list like. since I am an sql nit-wit...I have no idea how you would get something like: ticket|states 2 assigned,closed 3 assigned,accepted,new,closed ..... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
