[rt-devel] Where in DB are the requestors kept?

[Matt Knopp]

It is stored in the Watchers table.  You can divin the Requestor by looking 
for Watcher events where Type='Requestor' and Value=YourTicketID.

Of course this is the part where I remind you that generally speaking you 
generally really want to use the API and avoid using SQL because the odds 
of random sql changes between versions are much higher then random api 
changes. 

-Matt



On Tue, Jan 22, 2002 at 10:58:23AM -0800, Grant Miller wrote:
> In RT 2.0.11, where in the tables is the information that connects 
> the requestors of a ticket with the ticket?  If I have a Ticket id, how
> can I find the requestors using select statements?
> 
> I've been staring at the schema for a while and I can't find it.  
> 
> Thanks.
> 
> -- 
> 
> -Grant Miller    grant at pico.apple.com      x42917
> 
>  Unix Systems Admin, Engineering Compute Services
>  unix-support at pico.apple.com, http://www-ecs.apple.com
>  ECS Hotline: x44747
> 
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel