---

SELECT
    o.id AS operation_id,
    field.key AS link_field,
    field.value AS link_value
FROM back_office.operation o
LEFT JOIN LATERAL (
    SELECT e.key, e.value
    FROM jsonb_each_text(to_jsonb(o)) e
    WHERE e.value IS NOT NULL
      AND (
          e.key ILIKE '%decision%'
          OR e.key ILIKE '%charge%'
      )
) field ON true
WHERE o.id IN (
    79531249,
    79852424,
    84212555,
    84208221,
    84209112,
    84211596,
    84213346,
    79490301,
    79536678,
    79811972
)
ORDER BY o.id, field.key;