Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-20239

REST API to check responsibility from a broken build

XMLWordPrintable

    • 0
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      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

              mwalerianczyk Marcin Walerianczyk
              dsantos Daniel Santos (Inactive)
              Votes:
              38 Vote for this issue
              Watchers:
              30 Start watching this issue

                Created:
                Updated:
                Resolved: