X-Git-Url: http://wagnertech.de/git?p=kivitendo-erp.git;a=blobdiff_plain;f=templates%2Fwebpages%2Fcustom_data_export_designer%2Fedit.html;fp=templates%2Fwebpages%2Fcustom_data_export_designer%2Fedit.html;h=9b8f68cfe98a89104d84c80ce028efb4464ba82d;hp=0000000000000000000000000000000000000000;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hpb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44 diff --git a/templates/webpages/custom_data_export_designer/edit.html b/templates/webpages/custom_data_export_designer/edit.html new file mode 100644 index 000000000..9b8f68cfe --- /dev/null +++ b/templates/webpages/custom_data_export_designer/edit.html @@ -0,0 +1,49 @@ +[% 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" +