[rt-users] Silly Question

[Jesse Vincent]

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
> that?
> 
> Thanks,
> 
> Derek
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.