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

Stefan Oeser Stefan.Oeser at emendis.de
Fri Sep 1 05:04:23 EDT 2006


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?
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



More information about the rt-users mailing list