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.
Best regards. Ruslan.
btw, the following pointer contains a dead link:
Use variant from Steve[*] or build your own graph from .dot file.