It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Modifying "Export to CSV" of review history

Is there an easy way to modify the contents/format of the review history "Export to CSV" from a Crucible review (that is, not going through the back end)? Specifically, we'd like to modify it so that defects are clearly marked as such instead of just as a "comment", with their ranking and classification, and any Jira issue # that may have come from it. We need to have some form of evidence we're conducting these reviews for when auditing happens, and the output as is doesn't quite fulfill our needs.

2 answers

1 accepted

1 vote
Answer accepted

Hi Kattie,

I'm afraid the CSV report you mentioned is not customisable at the moment. But there is a way to retrieve the informations you are looking for in structured form using REST API. Take a look at Crucible REST API https://docs.atlassian.com/fisheye-crucible/latest/wadl/crucible.html, specifically the GET /rest-service/reviews-v1/{id} call. For defect like https://fisheye4.atlassian.com/cru/CR-22#c114you can load details of CR-22 review by hitting https://fisheye4.atlassian.com/rest-service/reviews-v1/CR-22/detailsendpoint. Interesting bits you get back:

{
 ...
    "stats": [
        {
            "defects": 1,
             ...
        }
    ],
 ...
    "versionedComments": {
        "comments": [
            {
                "createDate": 1340815287263,
                "defectApproved": false,
                "defectRaised": true,
                ...
                "message": "System.exit() is problematically when using embedded glassfish.",
               ...
                "metrics": {
                    "classification": {
                        "configVersion": 1,
                        "value": "Risk-prone"
                    }
                },
               ...
            }
        ]
    }

Hope that helps,
Piotr

That did help get us going in the right direction, thank you!

no worries, I'm glad it helped.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Teamwork

The Confluence blog has a brand-new look AND brand-new content!

Hey Community,  Last year, the Confluence team shipped "Team Central," a hub of articles and templates on topics like project planning, knowledge sharing, and more.  We're thrilled to...

26 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you