date error in mapping

[mfinanz.git] / templates / webpages / custom_data_export_designer / edit.html

diff --git a/templates/webpages/custom_data_export_designer/edit.html b/templates/webpages/custom_data_export_designer/edit.html
index 9b8f68cfe98a89104d84c80ce028efb4464ba82d..9008759b22742cc7ea6817f641a31308ade84823 100644 (file)
--- a/templates/webpages/custom_data_export_designer/edit.html
+++ b/templates/webpages/custom_data_export_designer/edit.html
@@ -41,8 +41,7 @@
 SELECT extract(YEAR FROM oe.transdate) AS "Jahr", SUM(oe.amount) AS "Angebotssumme"
 FROM oe
 LEFT JOIN employee ON (oe.employee_id = employee.id)
-WHERE (oe.customer_id IS NOT NULL)
-  AND COALESCE(oe.quotation, FALSE)
+WHERE oe.record_type = 'sales_quotation'
   AND (employee.login = <%Benutzer-Login%>)
 GROUP BY "Jahr"
 ORDER BY "Jahr"