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

RTC Query for Field Missing a Date

Questions
Tags
Users
Badges
Jamie Schena
(53●15●21) Mar 17 '14, 9:11 a.m.
 Hello,

Is there a way to set up a query that would show all work items that do not have a particular date field filled in? I have a field called "Due Date" and would like to see all of the items that do not have a "Due Date." 

Thank you!
Jamie

0 votes

Comments
sam detweiler
Mar 17 '14, 9:23 a.m.

some date fields allow search for Unassigned (due date) and some don't  (Created Date)

1 answer
4,707 views
0 votes

Accepted answer

Permanent link
Piotr Aniola
(3.7k●1●17●38) Mar 17 '14, 9:26 a.m.
It is not possible to query for Unassigned in attributes of type
timestamp in the Web UI.
This is a known defect https://jazz.net/jazz/web/projects/Jazz%20Support%20%28Private%29#action=com.ibm.team.workitem.viewWorkItem&id=157599, fixed in 5.0.

It is, however, possible to query for unassigned date in Eclipse - there is a dedicated checkbox.
Jamie Schena selected this answer as the correct answer

1 vote

Comments
Jamie Schena
Mar 17 '14, 9:42 a.m.

Thank you very much! 

Piotr Aniola
Mar 17 '14, 9:47 a.m.

Just an additional remark:
in pre 5.0 versions, you can create a query that checks for unassigned date in Eclipse, save it, and later use it in Web. But if you ever edit the query in Web, the Unassigned date condition will be lost.

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: Mar 17 '14, 9:11 a.m.

Question was seen: 4,707 times

Last updated: Mar 17 '14, 9:47 a.m.

Confirmation Cancel Confirm