Pivotdarstellung von Detaildaten » Historie » Version 1
[X] Steffen A, 11.11.2025 09:10
| 1 | 1 | [X] Steffen A | h1. Pivotdarstellung von Detaildaten |
|---|---|---|---|
| 2 | |||
| 3 | * ParentSource definieren |
||
| 4 | * select als Pivot definieren |
||
| 5 | * where auf Parentdatensatz |
||
| 6 | |||
| 7 | <pre><code class="sql"> |
||
| 8 | with data as ( |
||
| 9 | select * from art where ak_nr = :ak_nr |
||
| 10 | ) |
||
| 11 | select GetFieldAlias( key ) AS "Feld", value AS "Wert" |
||
| 12 | from data, jsonb_each_text(to_jsonb(data)) |
||
| 13 | where GetFieldAlias( key ) <> key; |
||
| 14 | |||
| 15 | </code></pre> |
||
| 16 | |||
| 17 | |||
| 18 | |||
| 19 | !clipboard-202511110909-qr77g.png! |