Table Panel Columns to Rows

Hi All,

Managed to queried this:

With this query:

SELECT patchsession,
count(*) as Baseline,
COUNT (*) filter(where exempted='SKIP_L2_APPROVAL') AS SKIP_L2_APPROVAL
from patchtracking P, cycle C
where C.cyclename=$cyclename and P.patch_id=C.id 
group by patchsession

Is it possible to query it so that it display this:

                            UAT
------------               ----
Baseline                    78
Skipped with L2 Approval    14

Thanks,
HY

1 Like

Hi. I am stuck in similar problem. You got any solution.

1 Like

Any idea how to do this ?, We have a table which always ends up with one row , but with 50 columns
Can the columns become rows ?
we are using logs in Metric to pull all columns of the record

1 Like

Same here. Need this functionality

1 Like

I need this one as well, any updates ?

Maybe unnest can help you. I use it with Crate.io and I think is the same with Postgre.