On 7/23/07, James Moseley <[EMAIL PROTECTED]> wrote:
Your problem may have something to do with the following statement issued
in the 3.6.4 release notes:
"Use 'Watcher = X' inestead of 'Requestor = X OR Cc = X OR AdminCc = X' in
the SelfService interface. Both queries do quite the same job, but the
former is significantly faster."
I ran into query problems as well when trying to search via Requestor,
AdminCc, Cc, etc, after upgrading to 3.6.4.
These queries are being made from the query builder. There are many
different instances when users would need to search based on an email
address and said email address would not be a Watcher, or a privileged
user for that matter.
This part of the query seems to be the problem:
"FROM Tickets main CROSS JOIN Users Users_3"
Thanks,
Brian
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
