It's all about the answers!

Ask a question

RTC Query for Field Missing a Date

Jamie Schena (531521) | asked Mar 17 '14, 9:11 a.m.

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!

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

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

Accepted answer

permanent link
Piotr Aniola (3.7k11738) | answered 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, 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

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

Thank you very much! 

Piotr Aniola commented 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 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.