Actions
Pivotdarstellung von Detaildaten¶
- ParentSource definieren
- select als Pivot definieren
- where auf Parentdatensatz
with data as (
select * from art where ak_nr = :ak_nr
)
select GetFieldAlias( key ) AS "Feld", value AS "Wert"
from data, jsonb_each_text(to_jsonb(data))
where GetFieldAlias( key ) <> key;
Updated by [X] Steffen A 2 months ago · 1 revisions