X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/1ac4c07d0d3e6ffa8b39221dd865a6080bbae808..71dab32201ac432029963c7f0ce2b87adea2dd92:/SL/SEPA.pm

diff --git a/SL/SEPA.pm b/SL/SEPA.pm
index f2599a8b6..c62c2ce7d 100644
--- 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 (