[rt-users] Find tickets that are owned by requestors.

[Kevin Falcone]

On Wed, Aug 13, 2014 at 03:01:38PM +0200, Bartosz Maciejewski wrote:
> We are using scrip that auto change owner of the ticket to the person that
> first respond to unowned ticket. This prevents resolved tickets by NoBody user.
> 
> However from time to time, Requestor want to add something to the ticket that
> was created minute ago. In this case Requestor is Owner of its own ticket and
> ticket is not visible to Staff anymore.
> 
> My question is how I can search tickets with condition like Owner = Requestor?

Unfortunately, you either have to write some complicated SQL or some
perl code, there's no way to do that in TicketSQL.

Hopefully you've fixed your Scrip, or moved to using something that
doesn't have the bug you mention, such as
https://metacpan.org/pod/RT::Action::AssignUnownedToActor

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140813/9e5162c6/attachment.sig>