[rt-users] Search Query Builder, how to write "NOT"

Ruslan Zakirov ruslan.zakirov at gmail.com
Fri Sep 1 06:34:21 EDT 2006


On 9/1/06, Stefan Oeser <Stefan.Oeser at emendis.de> wrote:
> Hello,
>
>   I wanna build a SearchQuery which presents me all my open and stalled tickets,
> but without the one with Starting-Time in the future. My Problem, not at all tickets
> the Value "Starts" is set, so my idea was to build a Query like:
>
> Owner = '__CurrentUser__' AND  (  Status = 'new' OR Status = 'open' ) AND NOT (  Starts > 'now' )
>
> But RT does not understand the Word NOT, does it?
It doesn't, but you always can use (  Starts <= 'now' ) which is the same.

> Only AND and OR, and I don't know how to include the tickets with the unset Value "Starts".
> Any helpful Idea how to do this???
>
> Thx a lot,
> Stefan
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.



More information about the rt-users mailing list