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

Provide a way to retrieve tests duration programmatically

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • REST API
    • None

    • 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

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

            Dates

              Created:
              Updated: