On 05/04/2011 03:10 PM, MikeKatPayPal wrote:
Is it possible to use data from ticket history for report or query purposes.
Yes, I do it all the time.
For example, can I find the last owner of a ticket or if a ticket had ever been in a certain state in it's history?
Brush up on your SQL-fu and have at it. The DB is pretty clearly laid out - half an hour of poking around should find where what you need lives, and then it's just a matter of grabbing that from a script in your favorite language.
Alternatively, you can do it with the Trac API directly, but that does generally mean writing it in Python.
-- Matthew Caron Build Engineer Sixnet | www.sixnet.com O +1 518 877 5173 Ext. 138 F +1 518 602 9209 [email protected] -- 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.
