Where is the AdministratorCc field?

RT Users
1

Hello All,
I’m using RT 3.0.11 and I’m trying to generate a report from mysql and
I need to query for the AdministratorCc data with respect to ticket
IDs. I cannot find the AdministratorCc field in any of the RT tables.

Can anyone tell me how to query for the AdministratorCc field given a ticket ID?

Thanks in advance.
Larry

2

Lawrence Wong wrote:

Hello All,
I’m using RT 3.0.11 and I’m trying to generate a report from mysql and
I need to query for the AdministratorCc data with respect to ticket
IDs. I cannot find the AdministratorCc field in any of the RT tables.
It’s Ticket role group.
See Request Tracker Wiki

Can anyone tell me how to query for the AdministratorCc field given a ticket ID?
Use RT API as much as possible.

3

Ruslan,
Thanks for the quick reply, but what is Ticket role group?
I only need the “table name” and the “field name”, where I can query
for AdministratorCc data.

btw, the following pointer contains a dead link:
http://wiki.bestpractical.com/index.cgi?DBSchema

Thanks,
LarryOn Thu, 04 Nov 2004 15:10:20 +0300, Ruslan U. Zakirov ruslan.zakirov@acronis.com wrote:

Lawrence Wong wrote:

Hello All,
I’m using RT 3.0.11 and I’m trying to generate a report from mysql and
I need to query for the AdministratorCc data with respect to ticket
IDs. I cannot find the AdministratorCc field in any of the RT tables.
It’s Ticket role group.
See Request Tracker Wiki

Can anyone tell me how to query for the AdministratorCc field given a ticket ID?
Use RT API as much as possible.

Thanks in advance.
Larry

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

4

Larry wrote:

Ruslan,
Thanks for the quick reply, but what is Ticket role group?
I only need the “table name” and the “field name”, where I can query
for AdministratorCc data.
Here is small query that does what you want:
SELECT DISTINCT t.id TicketId, u.id UserId, u.EmailAddress, g.Type
GroupType FROM Tickets t, Groups g, Principals p, CachedGroupMembers
cgm, Users u, Principals pu WHERE (p.id = g.id AND p.PrincipalType =
‘Group’ AND p.Disabled = 0) AND (g.Instance = t.Id AND g.Domain =
‘RT::Ticket-Role’) AND (pu.id = u.id AND pu.PrincipalType = ‘User’ AND
pu.Disabled = 0 ) AND (cgm.GroupId = p.id AND cgm.MemberId = pu.id) AND
t.id = XXXXXX;

Could I say “field name” and “table name”? As you can see you should
query from five tables and there is more then one condition in the
query that makes it correct. :slight_smile:

			Best regards. Ruslan.

btw, the following pointer contains a dead link:
Request Tracker Wiki
Use variant from Steve[*] or build your own graph from .dot file.