It's all about the answers!

Ask a question

How can audit history of Requirements be exported to excel?


Jeffrey Burke (312637) | asked Jan 26 '15, 1:34 p.m.
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



permanent link
Erica Tran (1.4k7) | answered Jan 28 '15, 2:28 p.m.
JAZZ DEVELOPER
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}

Comments
Jeffrey Burke commented Jan 29 '15, 8:41 a.m.

Thanks Erica!


permanent link
Edgar Ignacio Velazquez Mar (7225) | answered Jan 28 '15, 2:58 p.m.
JAZZ DEVELOPER
 You can probably export to HTML and import to Excel from that, tho it will require some manual copy paste or some scripting 

Comments
Jeffrey Burke commented Jan 29 '15, 8:42 a.m.

Thanks Edgar!


permanent link
Bob 3 (1482067) | answered Jun 29 '17, 1:20 p.m.

@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"/>
<link rel="self" href="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/>
<content type="application/rdf+xml" src="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/>
</entry> </feed>

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.