Provide a way to retrieve tests duration programmatically

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: REST API
    • None

      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

       

              Assignee:
              Unassigned
              Reporter:
              Daniel Santos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated: