<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 28, 2016 at 11:41 AM, Kenneth Marshall <span dir="ltr"><<a href="mailto:ktm@rice.edu" target="_blank">ktm@rice.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Mon, Nov 28, 2016 at 11:32:36AM -0500, Alex Hall wrote:<br>
> Thanks, I didn't know that would happen. I did that to suppress the email notification; we want users notified if their tickets change owners, but only if that change is NOT from "nobody" to themselves.<br>
><br>
> I just updated the script to record the transaction. It worked, because I got the email I wanted suppressed, and the owner still changed. Oddly, "nobody" is still the owner when I search for my ticket, though. Should I flush a cache or something? Mason cache wouldn't have anything to do with this, would it?<br>
<br>
</span>Hi Alex,<br>
<br>
Well, that is not what I would have expected to happen. I do not know enough<br>
about the DB queries that are being run to generate the search results. Probably,<br>
my next step would be to look at the actual query and see where the incorrect<br>
results are being produced. I am not much help because we use PostgreSQL as<br>
the DB and not MySQL. Sorry, I cannot be of more assistance.<br></blockquote><div><br></div><div>How do I view the actual query being used? Is there a way to get RT to store it, or some other trick? Thanks. <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Regards,<br>
Ken<br>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div>Alex Hall<br></div>Automatic Distributors, IT department<br></div><a href="mailto:ahall@autodist.com" target="_blank">ahall@autodist.com</a><br></div></div>
</div></div>