[rt-devel] Where in DB are the requestors kept?
mwatson at netspace.net.au
Tue Jan 22 17:30:07 EST 2002
its kept in the watchers table.
> -----Original Message-----
> From: rt-devel-admin at lists.fsck.com
> [mailto:rt-devel-admin at lists.fsck.com]On Behalf Of Grant Miller
> Sent: Wednesday, 23 January 2002 6:42 AM
> To: Alesh Mustar
> Cc: rt-devel at lists.fsck.com
> Subject: Re: [rt-devel] Where in DB are the requestors kept?
> 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
> rt-devel mailing list
> rt-devel at lists.fsck.com
More information about the Rt-devel