Automatically export Worktitems
Hi,
I would like to know if there is a way to export automatically the RTC / RQM version 4.x worktitems (e.g. command line or any other web services, REST...). The result of that operation could be a xml, json, text or any other exploitable format. Thanks for any feedback. |
2 answers
You should investigate the reportable REST API: https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI
This is what is used to populate the data warehouse via RRDI or Insight. A REST call such as this: https://<host:port>/ccm/rpt/repository/workitem?fields=workitem/workItem[id=123]/(id|summary|itemHistory/comments/content) will return the id and summary of the workitem, as well as all comment contents from each version of the workitem for workitem 123. The API is quite powerful and you can customize the sample REST call above to return more attributes from more workitems and include search predicates (including based on modified date) so that you are not retrieving the full contents of your repository every time you run it. |
well sort of yes,
if u create a query to identify the workitems, display that query result in the wed UI, select the printable form button or the export to csv and then get the URL from the browser.. then u can use curl or somesuch from the commandline to invoke that url again... |
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.
Comments
Thanks for your answer Sam.
I suppose that this way does not allow to get the full history of a workitem (e.g. the different comments, activity history linked to the status).
Thanks for any feedback.
correct.. only Export can get comments.. nothing will export history
If you want to export the full history, you would have to compute it e.g. using the API. A work item has up to two predecessor "states" and you can iterate from the current "State" to when it was created. The history view does exactly that. The information is there, but you would have to create your own export tool, if you want to export that too. You would need a different format than CSV to store all this information too.
right.. didn't say it wasn't possible, just that nothing provides this function today.