You’ve got a couple ways to do this:
Turn on query logging in mysql.
Turn on debugging in DBIx::SearchBuilder.
Write your code to use the RT API, rather than talking directly to the DB.On Tue, Nov 06, 2001 at 05:23:32PM -0500, Derek Buttineau wrote:
Just a quick question if Jesse can tell me quickly… I’ve been playing with
this for awhile but can’t seem to figure it out.
I’m trying to figure out the sql query to extract from the database a list
of ticket numbers associated to a particular requester address (not via web
interface… just through standard queries).
From what I can see in the Tickets table it only stores the Creator as a
reference (correct me if I’m wrong)…
If it’s changed at some point then it seems you need to query the Watchers
table to try and find what is owned…
The web interface does a good job of picking up the currently owned tickets
for a requester… I don’t suppose I could ask what the sql query behind
rt-users mailing list
http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.