Mailing List Archive: Trac: Users

Ticket metrics - historical status

Index | Next | Previous | View Threaded

smgrossen at comcast

Mar 22, 2012, 9:23 AM

Post #1 of 5 (244 views)
Permalink

Ticket metrics - historical status

Hello,

Is it possible to create a ticket report or query that will give me
tickets that were *ever* in a certain status. We would like to track
tickets that go back and forth from our QA team and so I need to see
tickets that in history, were in the reopened state.

Thanks!!

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

petsuter at gmail

Mar 22, 2012, 10:58 AM

Post #2 of 5 (247 views)
Permalink

Re: Ticket metrics - historical status [In reply to]

Hello,

On 22.03.2012 17:23, Marissa G wrote:
> Is it possible to create a ticket report or query that will give me
> tickets that were *ever* in a certain status. We would like to track
> tickets that go back and forth from our QA team and so I need to see
> tickets that in history, were in the reopened state.

I don't think it's possible with ticket queries, but a ticket report
could look at the ticket_change table (it stores the ticket history, one
field-change per row):

SELECT DISTINCT t.id AS id
FROM ticket t
LEFT JOIN ticket_change tc ON t.id = tc.ticket
WHERE tc.field='status' AND tc.newvalue = 'reopened'

This should list all tickets that were ever changed to status reopened.

--
Peter

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

smgrossen at comcast

Mar 22, 2012, 11:52 AM

Post #3 of 5 (241 views)
Permalink

Re: Ticket metrics - historical status [In reply to]

Awesome! How can I get a list of tables, fields ... db schema? (pardon
my ignorance, I am VERY new to Trac!)

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

petsuter at gmail

Mar 22, 2012, 12:09 PM

Post #4 of 5 (240 views)
Permalink

Re: Re: Ticket metrics - historical status [In reply to]

On 22.03.2012 19:52, Marissa G wrote:
> Awesome! How can I get a list of tables, fields ... db schema? (pardon
> my ignorance, I am VERY new to Trac!)
>

There some documentation at:
http://trac.edgewall.org/wiki/TracDev/DatabaseSchema

If your Trac installation is running on SQLite you could also create a
report that lists the known table names and the SQL statements that were
used to create them (where you can see the fields):

SELECT name, sql
FROM sqlite_master
WHERE type='table'

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

seccanj at gmail

Mar 22, 2012, 12:18 PM

Post #5 of 5 (244 views)
Permalink

Re: Re: Ticket metrics - historical status [In reply to]

Another option is to take a look at the file that actually defines the db
schema:

http://trac.edgewall.org/browser/branches/0.12-stable/trac/db_default.py

Tables, columns, keys and indexes come pretty well out of their object
definitions.

Ciao,
Roberto

2012/3/22 Peter Suter <petsuter [at] gmail>

> On 22.03.2012 19:52, Marissa G wrote:
>
>> Awesome! How can I get a list of tables, fields ... db schema? (pardon
>> my ignorance, I am VERY new to Trac!)
>>
>>
> There some documentation at:
> http://trac.edgewall.org/wiki/**TracDev/DatabaseSchema<http://trac.edgewall.org/wiki/TracDev/DatabaseSchema>
>
> If your Trac installation is running on SQLite you could also create a
> report that lists the known table names and the SQL statements that were
> used to create them (where you can see the fields):
>
> SELECT name, sql
> FROM sqlite_master
> WHERE type='table'
>
>
> --
> 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 [at] googlegroups
> To unsubscribe from this group, send email to trac-users+unsubscribe@**
> googlegroups.com <trac-users%2Bunsubscribe [at] googlegroups>.
> For more options, visit this group at http://groups.google.com/**
> group/trac-users?hl=en <http://groups.google.com/group/trac-users?hl=en>.
>
>

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads