Details
-
Suggestion
-
Resolution: Done
-
None
-
0
-
Description
Problem
As an admin I need to get the details from a broken build programatically though REST API.
Bamboo provides a lot of details for a given build through /rest/api/latest/result endpoint but the responsible information is not present there.
Suggestion
Expand the result endpoint to include this information or add a new endpoint for this
Workaround
Use the following query to get the details directly from the DB:
SELECT A.*, "USERNAME", "USER_WHO_UPDATED", BUILD_TYPE, CREATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, LIFE_CYCLE_STATE, BUILD_DATE, BUILD_CANCELLED_DATE, BUILD_COMPLETED_DATE, TRIGGER_REASON, REBUILD FROM "AO_7A45FB_AOTRACKING_USER" TU LEFT JOIN AUTHOR A ON A.LINKED_USER_NAME=TU."USERNAME" JOIN "AO_7A45FB_AOTRACKING_RESULT" TR ON TR."LINKED_TRACKING_ENTRY_ID"=TU."LINKED_TRACKING_ENTRY_ID" JOIN BUILDRESULTSUMMARY ON BUILDRESULTSUMMARY_ID="RESULT_SUMMARY_ID"
/!\ The query above was designed to work on Postgres DB and might need small adjustments to run on other DBMS
Attachments
Issue Links
- mentioned in
-
Page Loading...