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

REST API to check responsibility from a broken build

    XMLWordPrintable

Details

    • 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.

    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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: