On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes wrote:
RT3.8.4
If I use an unprivileged user (or a privileged user with no rights to see
queues or tickets) to create a very simple search that looks like this:
Requestor.EmailAddress Like 'email address'
then the apache process
Hi Kenneth,
I'm using MYSQL, How can I tell which query it is? I get no logging and nothing
in the MYSQL slow search log, I assume because it never completes?
Thanks,
Justin
-
Justin Hayes
Orbis Support Manager
justin.ha...@orbisuk.com
On 29
Hi Justin,
First of all use Requestor.EmailAddress = 'email address', so use =
instead of LIKE, in the query builder it is is operator. Second, add
index on CachedGroupMembers(MemberId, GroupId, Disabled) and on
Users(EmailAddress) if these are not there already.
On Thu, Apr 29, 2010 at 11:24
Hi Ruslan,
I have both of those indexes already, and in SelfService I have no control over
the query being run - it's just trying to show the 'My open tickets' panel.
Also there is no problem with SelfService with a privileged account that has
rights to see queues/tickets, so it seems to be
Hello,
On Thu, Apr 29, 2010 at 8:35 PM, Justin Hayes justin.ha...@orbisuk.com wrote:
Hi Ruslan,
I have both of those indexes already, and in SelfService I have no control
over the query being run - it's just trying to show the 'My open tickets'
panel.
My open tickets panel uses user's ID