Limiting Unowned tickets to queues

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.

Still, it seems like something someone else would have done already…
if anyone has an example or a pointer to an example it would be
appreciated.

Thanks
Mark Farver

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?

Cheers,
– jra
Jay R. Ashworth jra@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!

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?
Yeah, working solution was posted to the list less then month ago.

Cheers,
– jra

Jay R. Ashworth jra@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!

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.