Uploaded image for project: 'Bamboo'
  1. Bamboo
  2. BAM-20580

Provide a way to retrieve tests duration programmatically

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Gathering Interest (View Workflow)
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: REST API
    • Labels:
      None
    • Feedback Policy:

      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

      The test duration is available in every build result in the tests tab. We can see a breakdown of those results for jobs as well. 
      There is no way to retrieve test duration via REST API

      Workaround

      Retrieve the information from the DB

      SELECT TCL.TEST_CLASS_NAME
           , TCA.TEST_CASE_NAME
           , B.FULL_KEY
           , TCA.FIRST_BUILD_NUM
           , TCA.LAST_BUILD_NUM
           , TCA.AVG_DURATION
      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
      

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dsantos Daniel Santos
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated: