In report builder, how do a filter on an empty string?
In the example I am working on, I am trying to display all of the derived requirements in DNG which do not have a attribute called DerivedRationale filled in. For the text filter, my options are "contains", "does not contain", "is", "is not", "starts with" and "ends with". It won't let me leave the target field blank and I'm not sure how to get a null into the target field. What I really need is an "is empty".
Any ideas of what I can put in the filter and target fields to get this to work?
|
Accepted answer
For Work Items, I use the "is" filter and also select the "No set value" radio button to accomplish something like 'is empty'. I would guess you could do the same for DNG data. Andrew Takahashi selected this answer as the correct answer
|
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.