Re: [rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-09 Thread Thomas Sibley
On 10/05/2012 08:15 AM, Scotto Alberto wrote: Very interesting, thank you! Now I understand the relationships. So I think I should correct all the _Set I've used all around in my custom scrips :( Yes, rarely is _Set the right answer. To verify if it finds the errors caused by _Set I searched

Re: [rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-05 Thread Scotto Alberto
with _Set breaks queries (may be a bug) On 10/04/2012 04:05 AM, Scotto Alberto wrote: I think I found a bug. Not a bug in RT, only your scrip. :) Looks like _Set doesn’t update correctly some field in some table in the DB. But I have no idea of what field and what table! I had a quick look at the DB

[rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-04 Thread Scotto Alberto
Hi all, I think I found a bug. I have a scrip called On closure Auto set owner, which sets the owner while closing the ticket in case nobody has never taken it, so that I don't get resolved tickets assigned to Nobody in particular. Everything seemed ok until today a colleague of mine noticed

Re: [rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-04 Thread Joe Harris
This is a shot in the dark and I may be way off, but is there a chance your scrip to set the owner runs in a transaction that happens after the transaction that resolves the ticket? And the chart looks for the resolved transaction to get owner at the time of resolution? Just a thought. Sent

Re: [rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-04 Thread Scotto Alberto
[mailto:drey...@gmail.com] Sent: giovedì 4 ottobre 2012 13:37 To: Scotto Alberto Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Setting owner with _Set breaks queries (may be a bug) This is a shot in the dark and I may be way off, but is there a chance your scrip to set the owner runs

Re: [rt-users] Setting owner with _Set breaks queries (may be a bug)

2012-10-04 Thread Thomas Sibley
On 10/04/2012 04:05 AM, Scotto Alberto wrote: I think I found a bug. Not a bug in RT, only your scrip. :) Looks like _Set doesn’t update correctly some field in some table in the DB. But I have no idea of what field and what table! I had a quick look at the DB, and it seems that the relation