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

Is it possible to query on an empty field?

Questions
Tags
Users
Badges
Garren Linker
(11●2●2) Feb 13 '13, 11:54 a.m.
I have a work-item template with a custom field that is only to be filled in when certain conditions are met. I want to perform a query to see which work-items which have a value in that field. Is it possible?

0 votes

2 answers
4,807 views
0 votes

2 answers

Permanent link
Daniel Toczala
FORUM MODERATOR / JAZZ DEVELOPER (882●1●15●14) Feb 13 '13, 7:03 p.m.
 Sure.  Just choose the field in a custom query, and then in the box where it says "FIELDNAME is", click on the little decoration and select "FIELDNAME exists".

0 votes

Comments
Robert Huet
Jun 07 '13, 3:08 p.m.

I have the same problem, and using "exists" still brings back blank values for my custom string attribute.  Also, I have found no way to query on work items that have a blank value.  If I select "is" and leave the value blank, the condition disappears when I go to save the query.


Any help you can provide on this would be very helpful.
Thanks,
Robert 

Stuart Cornell
Feb 05 '14, 6:17 a.m.

I have the exact same issue. I need to find items where a particular custom field is blank. 

Lukas Steiger
Feb 05 '14, 6:48 a.m.

I was annoyed about this before as well. It looks like that there is already an open enhancement request for this. Vote for it so that the developers may priorize it

Permanent link
Bruno Fazoli
(8●5●6) Mar 25 '15, 8:57 a.m.
Hi,

Any update on that?
I need to find items where custom field is blank.

Regards

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 25 '15, 11:36 a.m.

Click on the link to the enhancement request in the last comment by Lukas, wait for the work item to open. Look at the state of the work item.

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,019

Question asked: Feb 13 '13, 11:54 a.m.

Question was seen: 4,807 times

Last updated: Mar 25 '15, 11:36 a.m.

Confirmation Cancel Confirm