Create an ALM report containing the run times broken down into seconds, minutes, etc.

Question ID: 109279
1
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 (Questions: 205, Answers: 14)
Asked on February 4, 2020 3:12 pm
13 views
Answers
1
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 (Questions: 2, Answers: 266)
Answered on February 4, 2020 3:14 pm
How do I get sec,min,hr in a single column rather than in 3 separate columns?
( at February 13, 2020 5:13 pm)