It's all about the answers!

Ask a question

Plans View Quick Query Syntax DueDate range based on today uses Union?

w h (191824) | asked Oct 16 '14, 3:08 p.m.
edited Oct 16 '14, 3:13 p.m.
Ignore the " " around the ">" - the site things I'm adding tags without the ""

I'm using 4.0.3 and the QuickQuerySyntax to color code work items by Due Date - If the work item is Due 7 days from today (dueDate:"<"today+7) it should color code the WI in yellow.  However, it looks like the syntax allows everything before today's date also. 

I tried adding another dueDate conditional but it just gives me every record that is Open. Any ideas, or is Intersection styled join available in later RTC versions, instead of Union?

Example using: stateGroup:Open  dueDate:"<"today+7 dueDate:">"today


One answer

permanent link
Neeraj Laad (324) | answered Feb 16 '16, 9:38 a.m.
edited Feb 16 '16, 9:51 a.m.

Did you get around this problem? I'm facing the same issue on RTC v5.0.2.
I just can seem to specify a range for due date.

I want all items with dues date between today and next 2 weeks to be in color yellow.

dueDate<today+15 dueDate>today resolved:false

above does not work. I tried various combinations.. including the one below:

dueDate<today+15 >today resolved:false

but just cant seem to get the expected behavior.

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.