[Trac] Re: Show all states the ticket has gone through
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: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] 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=gstq=group_concat#d73c2b5699491fa8 On Jun 24, 3:13 pm, yoheeb yoh...@gmail.com wrote: On Jun 24, 5:11 pm, yoheeb yoh...@gmail.com wrote: On Jun 23, 1:58 am, Sneha sneha.shet...@gmail.com 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 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 -~--~~~~--~~--~--~---
[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=gstq=group_concat#d73c2b5699491fa8 On Jun 24, 3:13 pm, yoheeb yoh...@gmail.com wrote: On Jun 24, 5:11 pm, yoheeb yoh...@gmail.com wrote: On Jun 23, 1:58 am, Sneha sneha.shet...@gmail.com 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 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 -~--~~~~--~~--~--~---
[Trac] Re: Show all states the ticket has gone through
On Jun 23, 1:58 am, Sneha sneha.shet...@gmail.com 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 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 -~--~~~~--~~--~--~---
[Trac] Re: Show all states the ticket has gone through
On Jun 24, 5:11 pm, yoheeb yoh...@gmail.com wrote: On Jun 23, 1:58 am, Sneha sneha.shet...@gmail.com 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 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 -~--~~~~--~~--~--~---