Search Query Builder, how to write "NOT"

RT Users
1

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

2

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.