RTC: Get list of WorkItem for chosen attributes at chosen date/time
Is it possible to retrieve data as listed in the title? The chosen date/time will be any chosen time in the past.
Example:
At the date/time July 7th / 12:00, the list of WI with Status: 'In Progress'
At the date/time July 8th / 12:00, the list of WI with Status: 'In Progress'
I see a couple forum questions using api that seem similar though not quite the same question.
Example:
At the date/time July 7th / 12:00, the list of WI with Status: 'In Progress'
At the date/time July 8th / 12:00, the list of WI with Status: 'In Progress'
I see a couple forum questions using api that seem similar though not quite the same question.
2 answers
The work Item queries only see the current values. If at all, you would have to use reporting. I am not familiar enough with reporting to know for sure, but I would not assume I can't report about this specific content. I would assume you could potentially do trends, but probably not get at the details.
What would be the purpose of this report? If you must have the data, but can't get t it otherwise, I would suggest to create an automation that is run on a regular basis and puts the work item ID's in a CSV file for each day.
What would be the purpose of this report? If you must have the data, but can't get t it otherwise, I would suggest to create an automation that is run on a regular basis and puts the work item ID's in a CSV file for each day.
I see several options:
- Use JRS. https://jazz.net/library/content/articles/jrs/6.0.1/historical-trends/
- Create an automation that is run on a regular basis and puts the work item ID's in a CSV file for each day, as Ralph suggested.
- Use the RTC API to generate such report. This requires effort to implement it, and the time required to run may be considerable, depending on the number of work items to retrieve, as it needs to go through the history of each one.
Hope this helps.