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

[Mat]

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
> http://lists.fsck.com/mailman/listinfo/rt-devel