I'd like to extract the 'minutes taken in total' for Tests from a specific job in a specific build.
Ideally, this could be done by the REST API, but I don't see the option for this, only buildDurationDescription, which is different.
URLs tried: http://bamboodev/rest/api/latest/result/HOME-NH2EPHC-JOB1-latest?expand=testResults.allTests and http://bamboodev/rest/api/latest/result/HOME-NH2EPHC-latest?expand=stages.stage.results.result.testResults
- where JOB1 is the Default Job and HOME-NH2EPHC is the build key.
I dug up this old thread, but the option suggested, "analyze the test result xml files stored on the Bambo server in the "builds" directory" doesn't seem feasible in my environment: https://community.atlassian.com/t5/Bamboo-questions/Is-there-a-way-to-get-at-the-test-running-time-data-in-Bamboo/qaq-p/152047
What are my other options? Are there suitable plugins, or is there something I have missed?
It would be great to get a history of test times for a build/job, but one step at a time...
I don't know any plugin used for this, but I don't know a lot of Bamboo plugins anyway.
As you already know, Bamboo REST API does not provide such information for tests.
In order to help you moving forward, I built the following query that may be useful to you. You might need to adjust it to your purpose, but at least you have a start.
FROM TEST_CASE TCA
JOIN TEST_CLASS TCL ON TCA.TEST_CLASS_ID=TCL.TEST_CLASS_ID
JOIN BUILD B ON TCL.MASTER_JOB_ID=B.BUILD_ID
I also created a feature request for this:
I hope that helps.