SEPA-Suche: Nachrichten-IDs als Spalte anzeigen

[kivitendo-erp.git] / SL / SEPA.pm

diff --git a/SL/SEPA.pm b/SL/SEPA.pm
index f2599a8b681b08562f34b4c7e9c357b14cb5221c..c62c2ce7d5f4b92ab4d29f3bff81f9758114abf4 100644 (file)
--- a/SL/SEPA.pm
+++ b/SL/SEPA.pm
@@ -370,6 +370,9 @@ sub list_exports {
          (SELECT SUM(sei.amount)
           FROM sepa_export_items sei
           WHERE (sei.sepa_export_id = se.id)) AS sum_amounts,
+         (SELECT string_agg(semi.message_id, ', ')
+          FROM sepa_export_message_ids semi
+          WHERE semi.sepa_export_id = se.id) AS message_ids,
          e.name AS employee
        FROM sepa_export se
        LEFT JOIN (