It's all about the answers!

Ask a question

Dowloading Work Item Attachments from a SQL Server Jazz database


Elizabeth Suku (111) | asked Sep 25 '13, 10:34 a.m.
We are moving away from RTC and I need to export all work Items and attachments from the tool. I was able to export all the work Items from the Tool interface but did not see an option to export  attachments. We have now decommissioned the tool and I now have access to the database alone. Can anybody help me with figuring out which tables in the SQl server Jazz database, will get me this data?

Thanks!

One answer



permanent link
Ralph Schoon (60.7k33643) | answered Sep 25 '13, 10:38 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
There is as far as I know no automation built in for that.

Please see: https://rsjazz.wordpress.com/2012/09/21/downloading-attachments-from-work-items/
and combine it with: https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/

I don't think you can easily get them from the database, but I am not sure because I always go trough the application to access data.

Your answer


Register or to post your answer.