[prev in list] [next in list] [prev in thread] [next in thread] 

List:       trac
Subject:    [Trac] Re: Show all states the ticket has gone through
From:       "Dan Winslow" <DWinslow () aiminstitute ! org>
Date:       2009-06-26 12:21:01
Message-ID: F276036850359C4D8F93F7B19189838203CC148B () exchmbox ! omaha ! org
[Download RAW message or body]


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-users@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=gst&q=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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


[prev in list] [next in list] [prev in thread] [next in thread]