Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

In report builder, how do a filter on an empty string?

Questions
Tags
Users
Badges
Andrew Takahashi
(13●1●3) Sep 25 '18, 10:09 a.m.

 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?

0 votes

1 answer
1,607 views
0 votes

Accepted answer

Permanent link
Jackie Albert
(1.6k●1●49●47) Sep 25 '18, 12:39 p.m.

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

0 votes

Comments
Andrew Takahashi
Sep 25 '18, 4:16 p.m.

 Thanks so much! Seems obvious now.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,029

Question asked: Sep 25 '18, 10:09 a.m.

Question was seen: 1,607 times

Last updated: Sep 25 '18, 4:16 p.m.

Confirmation Cancel Confirm