It's all about the answers!

Ask a question

More Questions on Expression filters in Plan

Aradhya K (1.4k54345) | asked Sep 11 '12, 5:29 a.m.
edited Sep 11 '12, 5:37 a.m.
 1. Article and mention " It consists of one or multiple words, separated by white space."  So my unerstanding is that if you specify for example "type:defect priority :High", it will display work items whose type is "defect" AND the priority is "High".  It's not necessary to add multiple filters to get "AND" effect.  Is this correct?

2. I understand that there is no "OR" filter. Is this correct?

3. Is there "Is NOT" filter?  e.g. show work items whose type IS NOT "defect"

4. Please let me know the available operators for filter expression.  Are they shown in the following page and is that all?

One answer

permanent link
Aradhya K (1.4k54345) | answered Sep 11 '12, 5:47 a.m.
 1. The multiple words here means the multiple words in the value part, not the complete expression. If you have expression on multiple attributes then you can create multiple filters or single filter itself. Both will give you the and effect. The only advantage of individual expressions is you can disable each of them from the filter tool bar.
2. No or condition in the filter expression is not default. If you have multiple conditions in the expression the root condition will be the and. Like for "not" we have ! or - there is no suffix for or supported.
3. Basically the filters will exclude the work items that matches the expression. If you want see just the work items of type defect then "!type:Defect"  will show only the Defects in the plan.
If you do not want to see the the the work items of type defect then "type:Defect"  will show the work items that are not of type Defects in the plan.
4. In the syntax attribute operator value the possible values of the operator are
Default ":"
Subtree "˜"
Eq "="
Lt "<"
Gt ">"

Chris Newton commented Jul 28 '14, 5:18 p.m.

Thank you for this explanation. The logic on the filter was throwing me off and now I've got the filtering working perfectly. 

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.