One of the nice ( but not easy ) things about SQLITE is that you can always write your own user function ( in C or C++ ) to make custom SQL-callable functions. You do not have to recompile or modify SQLITE itself but you do have to write your own function in a dynamically loaded library.
In MySQL I think they have stored procedure support now, and so you could write a SQL procedure that would accomplish your concatenation. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of RJOllos Sent: Thursday, June 25, 2009 8:28 PM To: Trac Users Subject: [Trac] Re: Show all states the ticket has gone through I remember that comment as well. I want to say that the comment was that the group_concat method needs to be replaced by some other method that is supported by sqlite, however the only thread I could find was this user with a similar problem, http://groups.google.com/group/trac-users/browse_thread/thread/882029b8268f59be/d73c2b5699491fa8?lnk=gst&q=group_concat#d73c2b5699491fa8 On Jun 24, 3:13 pm, yoheeb <[email protected]> wrote: > 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 theconcatmethod 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 -~----------~----~----~----~------~----~------~--~---
