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
-MattOn 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.
-Grant Miller email@example.com x42917
Unix Systems Admin, Engineering Compute Services
ECS Hotline: x44747
rt-devel mailing list