[rt-users] Limiting Unowned tickets to queues

Jay R. Ashworth jra at baylink.com
Tue Oct 25 19:21:47 EDT 2005

On Tue, Oct 25, 2005 at 01:55:43PM -0500, Mark Farver wrote:
> Just checking before I dive in and fix it myself, but does someone have 
> a different version of the unowned tickets element from the Home RT 
> screen that shows only the tickets in queues that the user has access 
> to?  The default version's query is "Owner = 'Nobody' AND ( Status = 
> 'new' OR Status = 'open')" which can get filled up with irrelevent tickets.
> The hangup is that it seems like it would have to be a multiple query 
> thing, find all the queues the user has access to (Take or maybe 
> SeeQueue) and loop thru adding them as another limit to the above query.

Nah; you just need a subquery.  I *think* I've seen this; have you
skimmed the archive, and checked the wiki?

-- jra
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

	"NPR has a lot in common with Nascar... we both turn to the left."
		- Peter Sagal, on Wait Wait, Don't Tell Me!

More information about the rt-users mailing list