[rt-users] location of requestors in the database
Benjamin Ortega
ortega at hist.umn.edu
Mon Apr 5 12:53:34 EDT 2004
Hello,
I'm in the process of writing a few SQL queries to generate reports from
the RT 3.0.8 database. I've got queries to do everything except this:
I want to list resolved and open tickets from the past month, grouped by
their Requestors. I've looked in the Transactions table, and in the
Tickets table, and pretty much everywhere, and I can't find where the
Requestor IDs are being stored. I know that they're recorded in the
Transactions table if you add them after the fact, but they must be
stored somewhere else, because when a user submits something via e-mail
they become the Requestor and there isn't a corresponding AddWatcher
record in the Transactions table. I could use the Creator field in the
Tickets table, but it's not always reliable since we manually enter
tickets for people from time to time.
Has anyone figured this out?
--
Benjamin Ortega Minnesota Population Center
Applications Programmer University of Minnesota
ortega at hist.umn.edu http://www.pop.umn.edu
More information about the rt-users
mailing list