Where is the AdministratorCc field?

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

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 http://wiki.bestpractical.com/index.cgi?DBSchema

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

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 http://wiki.bestpractical.com/index.cgi?DBSchema

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

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:
http://wiki.bestpractical.com/index.cgi?DBSchema
Use variant from Steve[*] or build your own graph from .dot file.