It's all about the answers!

Ask a question

RTC v4.0.2 REST API: How to query for work items that changed within a specific time frame


Paul Eaton (823) | asked Jun 25 '14, 4:25 a.m.
edited Jun 25 '14, 4:26 a.m.
I have been trying to find out how I can constrain my RTC work item queries so that it only returns work items that have been changed:-

1. In the last month, week, day or hour.
2. Between this date and that date.

The *only* example that I have been able to find is the following:-

workitem/workItem[modified > 2010-12-07T10:10:53.000-0500]/(id|summary)

I changed this to the following:-

workitem/workItem[modified > 2014-01-01T00:00:00.000-0000]/(id|summary)

and it didn't return anything, although there was no error either...

Can anyone tell me what is wrong with the above?

Can anyone tell me how to do the second query that I need - from this date to that date?

Thanks and regards,

Paul.

One answer



permanent link
Kevin Ramer (4.5k9186201) | answered Jun 25 '14, 4:30 p.m.
Hi, Paul

I think for all values that aren't integer one must use quotations. so modified > '2014-01-01T00:00:00.000-0000' ought to work.   If you want between dates add try

modified > '2014-01-01T00:00:00.000-0000' and modified < '2014-03-01T00:00:00.000-0000'  

in the 'where' part.

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.