[rt-users] History not displayed when visiting merged ticket
Bret Martin
bam at miranda.org
Fri Oct 15 12:03:03 EDT 2004
On Fri, 15 Oct 2004 11:50:46 EDT Jesse Vincent wrote:
> On Fri, Oct 15, 2004 at 11:43:00AM -0400, Bret Martin wrote:
> > RT 3.2.1: when I visit a merged ticket number, the metadata is
> > displayed, but no history. I have to visit the ticket into which the
> > ticket was merged to see the merged history for the two tickets. For
> > example:
> >
> > - Merge ticket #264 into #205
> >
> > - Type "264" into the search box: only metadata is displayed, no history
>
> That's not right. That's a bug. Can you poke a bit more and see if you
> can find out what's going on?
Attached is a query log from me viewing #264.
It looks to me like the SELECTs for Attachments and Transactions are
using "EffectiveId" 264, instead of 205. I assume EffectiveId is
really supposed to refer to the "master" ticket?
--Bret
-------------- next part --------------
041015 11:59:42 3676 Query SELECT * FROM Users WHERE Name = 'RT_System'
3676 Query SELECT * FROM Users WHERE Name = 'Nobody'
3676 Query SELECT GET_LOCK('Apache-Session-17e06cc4113893071a8bc73be37cc0d9', 3600)
3676 Query SELECT a_session FROM sessions WHERE id = '17e06cc4113893071a8bc73be37cc0d9'
3676 Query SELECT * FROM Users WHERE id = '22'
3676 Query SELECT * FROM Groups WHERE Type = 'Privileged' AND Domain = 'SystemInternal'
3676 Query SELECT * FROM Principals WHERE PrincipalType = 'User' AND ObjectId = '22'
3676 Query SELECT * FROM GroupMembers WHERE GroupId = '4' AND MemberId = '22'
3676 Query SELECT * FROM Tickets WHERE id = '264'
3676 Query SELECT * FROM Queues WHERE id = '1'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 264) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT * FROM Tickets WHERE id = '205'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicketComments') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicketComments') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 264) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ModifyTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ModifyTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 264) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'OwnTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'OwnTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '264') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 264) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT * FROM Users WHERE id = '29'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT main.* FROM CustomFields main WHERE ((main.Disabled = '0')) AND ((main.Queue = '1')OR(main.Queue = '0')) ORDER BY main.SortOrder ASC
3676 Query SELECT main.* FROM CustomFields main WHERE ((main.Disabled = '0')) AND ((main.Queue = '1')OR(main.Queue = '0')) ORDER BY main.SortOrder ASC
3676 Query SELECT main.* FROM TicketCustomFieldValues main WHERE ((main.CustomField = '1')) AND ((main.Ticket = '205')) ORDER BY main.id ASC
3676 Query SELECT * FROM Groups WHERE Type = 'Requestor' AND Instance = '205' AND Domain = 'RT::Ticket-Role'
3676 Query SELECT DISTINCT main.* FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '943')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ORDER BY main.Name ASC
3676 Query SELECT DISTINCT main.* FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 943)) AND ((main.MemberId = Principals_1.id))
3676 Query SELECT * FROM Groups WHERE Type = 'Cc' AND Instance = '205' AND Domain = 'RT::Ticket-Role'
3676 Query SELECT DISTINCT main.* FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '945')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ORDER BY main.Name ASC
3676 Query SELECT DISTINCT main.* FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 945)) AND ((main.MemberId = Principals_1.id))
3676 Query SELECT * FROM Groups WHERE Type = 'AdminCc' AND Instance = '205' AND Domain = 'RT::Ticket-Role'
3676 Query SELECT DISTINCT main.* FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '946')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ORDER BY main.Name ASC
3676 Query SELECT DISTINCT main.* FROM GroupMembers main , Principals Principals_1 WHERE ((Principals_1.PrincipalType = 'Group')) AND ((main.GroupId = 946)) AND ((main.MemberId = Principals_1.id))
3676 Query SELECT * FROM Users WHERE id = '637'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '205') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '205') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 205) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'DependsOn')) ORDER BY main.Target ASC
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT main.* FROM Links main WHERE ((main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'DependsOn')) ORDER BY main.Base ASC
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'MemberOf')) ORDER BY main.Target ASC
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT count(main.id) FROM Links main WHERE ((main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'MemberOf'))
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT main.* FROM Links main WHERE ((main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Base = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'RefersTo')) ORDER BY main.Target ASC
3676 Query SELECT * FROM Tickets WHERE id = '114'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '114') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '114') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 114) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT main.* FROM Tickets main WHERE ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.EffectiveId = '205') ) )
3676 Query SELECT main.* FROM Links main WHERE ((main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/205')OR(main.Target = 'fsck.com-rt://rt.med.harvard.edu/ticket/264')) AND ((main.Type = 'RefersTo')) ORDER BY main.Base ASC
3676 Query SELECT DISTINCT main.Id AS id, main.Filename AS filename, main.ContentType AS contenttype, main.Headers AS headers, main.Subject AS subject, main.Parent AS parent, main.ContentEncoding AS contentencoding, main.ContentType AS contenttype, main.TransactionId AS transactionid, main.Created AS created FROM Attachments main , Transactions Transactions_1, Tickets Tickets_2 WHERE ((Tickets_2.EffectiveId = '264')) AND ((Transactions_1.Ticket = Tickets_2.id)) AND ((main.TransactionId = Transactions_1.id))
3676 Query SELECT DISTINCT main.* FROM Users main , Principals Principals_1, CachedGroupMembers CachedGroupMembers_2 WHERE ((CachedGroupMembers_2.GroupId = '943')) AND ((CachedGroupMembers_2.MemberId = Principals_1.id)) AND ((Principals_1.Disabled = '0')) AND ((main.id = Principals_1.id)) ORDER BY main.Name ASC
3676 Query SELECT * FROM Principals WHERE PrincipalType = 'User' AND ObjectId = '1109'
3676 Query SELECT * FROM GroupMembers WHERE GroupId = '4' AND MemberId = '1109'
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'AdminUsers') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::System' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT DISTINCT main.* FROM Tickets main , Groups Groups_1, CachedGroupMembers CachedGroupMembers_2, Users Users_3 WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( ( (Users_3.EmailAddress = 'richard_krieg at hms.harvard.edu')AND(Groups_1.Domain = 'RT::Ticket-Role')AND(main.id = Groups_1.Instance)AND(Groups_1.Type = 'Requestor')AND(Groups_1.id = CachedGroupMembers_2.GroupId)AND(CachedGroupMembers_2.MemberId = Users_3.id) ) ) AND ( (main.Status = 'new')OR(main.Status = 'open') ) ) ORDER BY main.Priority DESC LIMIT 10
3676 Query SELECT * FROM Principals WHERE PrincipalType = 'User' AND ObjectId = '607'
3676 Query SELECT * FROM GroupMembers WHERE GroupId = '4' AND MemberId = '607'
3676 Query SELECT DISTINCT main.* FROM Tickets main , Groups Groups_1, CachedGroupMembers CachedGroupMembers_2, Users Users_3 WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( ( (Users_3.EmailAddress = 'todd_deluca at hms.harvard.edu')AND(Groups_1.Domain = 'RT::Ticket-Role')AND(main.id = Groups_1.Instance)AND(Groups_1.Type = 'Requestor')AND(Groups_1.id = CachedGroupMembers_2.GroupId)AND(CachedGroupMembers_2.MemberId = Users_3.id) ) ) AND ( (main.Status = 'new')OR(main.Status = 'open') ) ) ORDER BY main.Priority DESC LIMIT 10
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '236') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '236') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 236) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '237') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '237') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 237) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '43') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '43') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 43) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '130') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '130') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 130) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '131') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '131') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 131) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '268') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '268') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 268) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '97') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '97') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 97) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '258') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND (Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) LIMIT 1
3676 Query SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicket') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = '22' AND ( ACL.ObjectType = 'RT::System' OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = '258') OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ((Groups.Domain = 'RT::Ticket-Role' AND Groups.Instance = 258) OR (Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = 'Group') LIMIT 1
3676 Query SELECT DISTINCT main.id AS id, main.Content AS content, main.ContentType AS contenttype, main.TransactionId AS transactionid, main.ContentEncoding AS contentencoding FROM Attachments main , Transactions Transactions_1, Tickets Tickets_2 WHERE ((Tickets_2.EffectiveId = '264')) AND ((Transactions_1.Ticket = Tickets_2.id)) AND ((main.ContentType = 'text/plain')or(main.ContentType LIKE 'message/%')or(main.ContentType = 'text')) AND ((main.TransactionId = Transactions_1.id))
3676 Query SELECT DISTINCT main.* FROM Transactions main , Tickets Tickets_1 WHERE ((Tickets_1.EffectiveId = '264')) AND ((main.Ticket = Tickets_1.id)) ORDER BY main.Created ASC, main.id ASC
3676 Query SELECT RELEASE_LOCK('Apache-Session-17e06cc4113893071a8bc73be37cc0d9')
More information about the rt-users
mailing list