[rt-users] Limiting Unowned tickets to queues

Ruslan Zakirov ruslan.zakirov at gmail.com
Wed Oct 26 01:37:38 EDT 2005


On 10/26/05, Jay R. Ashworth <jra at baylink.com> wrote:
> 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?
Yeah, working solution was posted to the list less then month ago.

>
> Cheers,
> -- 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!
> _______________________________________________
> 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.



More information about the rt-users mailing list