It's all about the answers!

Ask a question

Filtering


Peter George (2651) | asked Oct 07 '11, 11:43 a.m.
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'.

2 answers



permanent link
Peter Haumer (2.2k12019) | answered Oct 07 '11, 9:22 p.m.
JAZZ DEVELOPER
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'.

permanent link
Peter George (2651) | answered Oct 10 '11, 2:47 p.m.
Thanks for all the help

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.