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

Query in RTC for "null" ?

Questions
Tags
Users
Badges
Karl Hegarty
(1●1●1) May 18 '12, 8:05 a.m.
We are using tag field and I want to be able to query for tags not set i.e. null.

0 votes

1 answer
9,084 views
0 votes

One answer

Permanent link
Millard Ellingsworth
FORUM ADMINISTRATOR / JAZZ DEVELOPER (2.5k●1●24●31) May 18 '12, 1:06 p.m.
We are using tag field and I want to be able to query for tags not set i.e. null.


This works well -- depending on who you ask to do the work for you. :oops:

I created a new query in the Web UI, added the Tags field and left the value part empty. When I run the query, only items with no tag values are displayed. I was able to save the query and run it later with the same result.

However, creating what seems to be the exact same query from Eclipse query editor does not work. Even worse, if you open the query you saved from the Web UI in Eclipse, it will "break" if you save it.

So the easy workaround is to use the Web UI to create the query and save it. You can even run it in the Eclipse UI and get the proper results -- just don't edit it in Eclipse.

I have filed a defect to track this issue: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=212379

0 votes

Comments
Paul Sappie
Feb 07 '13, 3:23 p.m.
How would I create a query for values that are "not null" in the tag field. I'm looking for a list of ALL tags.

Ryan McBryde
Mar 21 '14, 10:50 a.m.
Does this "solution", creating the query in the web client work in release 4.0? I tried to create a query, in the web client, with a custom field, which uses an HTTP filtered value set, and tried to leave the value part empty.  When I save the condition on that field simply disappears.  Does it for contains, is, is not, etc.  Any reason why "is not null" was not included as a criteria when the tool was designed?

Ginny Ghezzo
JAZZ DEVELOPER Mar 21 '14, 12:47 p.m.
Ryan: I tried the original scenario (Tags) in 5.0 self host on jazz and a 4.0.6 server.   They both worked as Millard described above.   I did not try your scenario of a custom field.

Reenu Marina Thomas
Jan 14 '16, 10:55 p.m.
Hello, What would it be for a field like Estimate? If there is no estimation made, I tried leaving the attribute condition empty, but i also shows work items that have an estimate. Is there anything else apart from estimate <= 0?

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

Question asked: May 18 '12, 8:05 a.m.

Question was seen: 9,084 times

Last updated: Jan 14 '16, 10:55 p.m.

Confirmation Cancel Confirm