Using postgres 8.3.1 and RT 3.8.2 Hi I have a very odd problem - I am working on a develpment branch of our software in which the sort by requestors or by custom fields in the search results table stopped working.
I researched it for a while and i compared it with an older version of our software, extracting the SQL query after OrderByCols call and I saw this query: SELECT main.* FROM ( SELECT main.id FROM Tickets main JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) LEFT JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId != CachedGroupMembers_2.MemberId ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) LEFT JOIN Users Users_3 ON ( Users_3.id = CachedGroupMembers_2.MemberId ) WHERE (main.Status != 'deleted') AND (main.Queue = '1' AND ( main.Queue = '1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY main.id ORDER BY MIN(Users_3.EmailAddress) ASC ) distinctquery, Tickets main WHERE (main.id = distinctquery.id) trying this query on the older version worked fine (and when I make the order DESC it change the results) while on the devel version it doesn't matter it just won't order it for me. I suspected that the problem is that the order is inside the subquery and AFAIK (and asked in postgresql IRC) join doesn't keep the order. I wonder if it worked only by accident or if I am missing something
RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!