It's all about the answers!

Ask a question

RTC Query for export the Work item History via excel


RTC User Prime (213) | asked Apr 10 '22, 5:53 a.m.

Is there a way where we can have an RTC Query for export the Work item History via excel ? 


The requirement is to have to actually have the dates for State Transition but due to the dynamic change on "last Transaction Date", unable to get the initial set of transactions.

Any ideas / insights ?

One answer



permanent link
Ralph Schoon (63.1k33645) | answered Apr 11 '22, 2:13 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 I have not looked into the reporting aspect of this. So there might be something I am unaware of.


As far as I am a ware there is nothing out of the box that would allow to do that. 

A customer has created an extension to be able to see the status history in the Web UI: https://github.com/jazz-community/rtc-statushistory-presentation

The EWM SDK/Plain Java Client Libraries allows to retrieve the historical states of a work item. Based on that you should be able to access the auditable history, including workflow sate changes using:

com.ibm.team.repository.client.IItemManager.fetchAllStateHandles(IAuditableHandle, IProgressMonitor)

You can then resolve all these history states of the work item, sort them and get at the data you want. 

Just y 2 cents. 


Comments
Ralph Schoon commented Apr 11 '22, 2:33 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

com.ibm.team.repository.client.IItemManager.fetchCompleteStates(List, IProgressMonitor) would allow to get the historical state of the item.  

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.