How can audit history of Requirements be exported to excel?
How can audit history of Requirements be exported to excel?
I see how to export audit history to pdf (via a report). And I can export the Requirements record (but only certain attributes) to excel. But don't see how to export the audit history of a Requirements record to an excel file. Thanks! |
3 answers
Hi Jeffrey,
There is no feature that exports audit history to Excel. You can get history to return in the form of a feed using the URL below. https://{host:port}/rm/revisions?accept=*&private=true&url=https://{host:port}/rm/resources/{UUID} |
You can probably export to HTML and import to Excel from that, tho it will require some manual copy paste or some scripting
|
@Erica Tran: I tried your approach using DNG 6.0.3 on a DNG artifact with lots of changes, and this is all I receive in the feed. Does this technique still work? If so, any idea what I did wrong?
<?xml version="1.0" encoding="utf-8"?><feed xmlns="http://www.w3.org/2005/Atom">
<title>https://myurl.com:9443/rm/history</title> <id>urn:uuid:_opFpYFzuEeeoVevQThs3UQ</id> <updated>2017-06-29T17:16:05.750Z</updated> <link rel="self" href="https://myurl.com:9443/rm/history" type="application/atom+xml;type=feed"/> <generator>Jazz Resource Services</generator> <entry> <title>https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg</title> <author><name>https://myurl.com:9443/jts/users/bp3</name></author> <summary/> <id>urn:uuid:_opFpYVzuEeeoVevQThs3UQ</id> <updated>2017-06-28T23:45:24.174Z</updated> <link rel="alternate" href="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/> |
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.