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

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

Questions
Tags
Users
Badges
Paul Eaton
(8●2●3) 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.

0 votes

1 answer
4,020 views
0 votes

One answer

Permanent link
Kevin Ramer
(4.5k●9●186●201) 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.

0 votes

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
× 10,938

Question asked: Jun 25 '14, 4:25 a.m.

Question was seen: 4,020 times

Last updated: Jun 25 '14, 4:30 p.m.

Confirmation Cancel Confirm