Create an ALM report containing the run times broken down into seconds, minutes, etc.
| ♥ 1 |
Hello. I am trying to create a query that will provide a report containing the run times broken down into seconds, minutes, etc. So far, I have the following query, but I keep receiving an error. Can you help me with this? Thanks! SELECT rn_test_id, sum(rn_duration) as sec, sum(rn_duration) / 60 as min, sum(rn_duration) / 3600 as hr FROM run where CYCLE.CY_FOLDER_ID /*Test Set.Test Set Folder*/ like ‘Loan & Account Servicing_18_Q2’ group by rn_test_id
Marked as spam
|
Posted by |
Private answer
Hello. The query below should get you the results you are looking for. If you need further assistance with the query, please let me know. SELECT RN_TEST_ID as 'Run ID', SUM(RN_DURATION) as 'Sec', SUM(RN_DURATION) / 60 as 'Min', SUM(RN_DURATION) / 3600 as 'Hr' FROM RUN, CYCLE, CYCL_FOLD WHERE CF_ITEM_NAME = 'TestSet Folder Name' AND CF_ITEM_NAME = CY_CYCLE AND CY_CYCLE_ID = RN_CYCLE_ID GROUP BY RN_TEST_ID Marked as spam
 Posted by jameslcoleman (Questions: 2, Answers: 300) Answered on February 4, 2020 3:14 pm
|