Untitled

CREATE OR REPLACE VIEW "joined_batches_fieldmapperview_290" AS 
SELECT T1_1.id                   AS id,
       T1_1.added                AS added,
       T1_1.updated              AS updated,
       T1_1.notes                AS notes,
       T1_1.uid                  AS uid,
       T1_1.relates_to_id        AS relates_to_id,
       T1_1.role_id              AS role_id,
       T1_1.row                  AS row,
       T1_1.fields || coalesce(T1_2.fields, '{}'::JSONB) || coalesce(T1_3.fields, '{}'::JSONB) AS fields

FROM "data_record" T1_1 LEFT OUTER JOIN "data_record" T1_2 ON T1_1.fields ->> 'F_114481' = T1_2.fields ->> 'F_113923' LEFT OUTER JOIN "joined_batches_fieldmapperview_290" T1_3 ON T1_1.T1_1__row = T1_3.row
WHERE T1_1."role_id" = 7181 AND T1_2."role_id" = 7179
ORDER BY T1_1."role_id" = 7181 AND T1_2."role_id" = 7179