Create a table of summed step statuses : Bienabee

Create a table of summed step statuses Print

Modified on: Sat, 23 Apr, 2016 at 8:04 PM

This query will create a table that sums all the statuses of a specific run. I used this to tally up step statuses and in an effort to record some sort of history on steps.

Select

sum(case when st_status = 'Passed' then 1 else 0 end) as "Passed",

sum(case when st_status = 'Failed' then 1 else 0 end) as "Failed",

sum(case when st_status = 'No Run' then 1 else 0 end) as "No Run",

sum(case when st_status = 'N/A' then 1 else 0 end) as "NA",

sum(case when st_status = 'Not Complete' then 1 else 0 end) as "Not Complete",

sum(case when st_status = 'Blocked' then 1 else 0 end) as "Blocked",

sum(case when st_status = '' then 1 else 0 end) as "Blank"

FROM step WHERE ST_RUN_ID = '16'

Did you find it helpful? Yes No

How can we help you today?

Create a table of summed step statuses Print

Related Articles