[rt-users] Selecting data directly from RT db

[Edge, Sean]

In the DB, Tickets.Creator should be the requestor.  This is a reference to Users.id.

-Sean

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of José de Paula Eufrásio Júnior
Sent: Monday, June 18, 2007 3:40 PM
To: RT-Users at lists.bestpractical.com
Subject: Re: [rt-users] Selecting data directly from RT db

Gene LeDuc wrote:
> Hello Jose,
> 
> Custom field values are associated with the ticket number.

I did the magic with custom fields and some joins, but there's something bugging me now: where RT stores the information about the 'Requestor' of a ticket?

[]s
core
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com



This email (including any attachments) is for its intended-recipient's
use only. This email may contain information that is confidential or
privileged.  If you received this email in error, please immediately
advise the sender by replying to this email and then delete this message
from your system.  For further information and disclaimers that apply to
this email, see [http://www.viacom.com/email_disclaimer.jhtml].