Filtering

Hello.
So, let's assume you want to list Requests that are not 'Closed'. Then
you just have to add a Detail Filter to your query with this expression:

.. <> 'Closed'

If you want to exclude several values you could do

.. NOT IN ('Resolved', 'Closed')

Rereading you question you could also ask for how to look for a
sub-string. For example to filter all the rows in which the name query
item contains the word IBM you would do

NOT contains 'IBM'

In the expression editor switch to the Functions tab. There you find
your whole arsenal of functions and expressions available to you.

Hope this helps,
Peter.



On 10/7/2011 9:08 AM, pgeorge wrote:

I know this is probably a simple question, but I cannot find or get
the syntax right. I was wondering what the syntax is if I am trying
to do a filter for a does not contain. What I am trying to do is pull
in a query that displays everything, but the rows that contain
'closed'.

Thanks for all the help