[% USE HTML %][% USE L %][% USE LxERP %]
[% LxERP.t8("The SQL query can be parameterized with variables named as follows: <%name%>.") %] [% LxERP.t8("On the next page the type of all variables can be set.") %] [% LxERP.t8("Note that parameter names must not be quoted.") %] [% LxERP.t8("Example") %]:
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) AND (employee.login = <%Benutzer-Login%>) GROUP BY "Jahr" ORDER BY "Jahr"