On Jun 24, 5:11 pm, yoheeb <[email protected]> wrote: > 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 > .....
wow, looking at it, I somehow missed your comment about already trying that...sorry, must have more coffee. There was a comment in this group about the concat method recently, might be worth a search. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
