Filtering
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
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 |
|
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.