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

[Grant Miller]

On Tue, Jan 22, 2002 at 08:36:10PM +0100, Alesh Mustar wrote:
> This SQL statement should help you:
> select Tickets.id, Tickets.Creator, Users.Name from Users, Tickets where
> Tickets.id=800 and Users.id=Tickets.Creator;
> 
> Replace Tickest.id with your ticket number(s) and ofcourse limit, expand
> the select fields.
> 
> Regards,
> A.


That only tells me who the Creator is, not the requestor.  In some cases
these are two different people, and there is usually more than one requestor.



-- 

-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