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

Grant Miller grant at pico.apple.com
Tue Jan 22 14:41:44 EST 2002

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

More information about the Rt-devel mailing list