Revision 1c77d03f
Von Tamino Steinert vor 8 Monaten hinzugefügt
templates/design40_webpages/custom_data_export_designer/edit.html | ||
---|---|---|
39 | 39 |
SELECT extract(YEAR FROM oe.transdate) AS "Jahr", SUM(oe.amount) AS "Angebotssumme" |
40 | 40 |
FROM oe |
41 | 41 |
LEFT JOIN employee ON (oe.employee_id = employee.id) |
42 |
WHERE (oe.customer_id IS NOT NULL) |
|
43 |
AND COALESCE(oe.quotation, FALSE) |
|
42 |
WHERE record_type = 'sales_quotation' |
|
44 | 43 |
AND (employee.login = <%Benutzer-Login%>) |
45 | 44 |
GROUP BY "Jahr" |
46 | 45 |
ORDER BY "Jahr" |
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt