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: