Modifying "Export to CSV" of review history

[Kattie Grady]

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.

[Piotr Swiecicki · Accepted solution]

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

[Kattie Grady]

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

[Piotr Swiecicki]

no worries, I'm glad it helped.