Query doesn't return multiple Modified Dates when queried by a date range
We have written a query with the expected result to be each modification date to a Work Item in a given date range. But the query doesn't return the different Modified Dates even though it has been modified multiple items. It only returns the latest modified date.
Is this a limitation of RTC (v5.0.2), or is there something wrong with our query?
Thank you in advance for your reply/answer.
Gary
Accepted answer
A work item only has a single Modified Date value. If you run a work item query, it is expected that you only see one Modified Date for each work item.
As said in my previous comment, if you want to access the work item history, which contains the modified date of each revision, you need to use the reportable REST API. An example is given below.
https://jazz.net/forum/questions/202796/how-to-access-rtc-work-item-history-using-rpe
For more details about the reportable REST API, see this article.
https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI
As said in my previous comment, if you want to access the work item history, which contains the modified date of each revision, you need to use the reportable REST API. An example is given below.
https://jazz.net/forum/questions/202796/how-to-access-rtc-work-item-history-using-rpe
For more details about the reportable REST API, see this article.
https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI
Comments
Donald Nong
Feb 24 '16, 10:04 p.m.What query is it? Work item query, OSLC query or reportable REST API query? If you are trying to access the history, I believe you can only use reportable REST API query, but you need to explain in more details for others to understand what you are actually trying to do.
Gary Woodward
Feb 25 '16, 12:11 p.m.Thank you Donald. I am using a Work Item query.