You can change data with checkboxes above the SQL report without adjusting the SQL code.
For this purpose, you will find four variables for free configuration in the Variables area.
Under Name you assign the name that is to be displayed above the SQL report for this variable.
With Default you assign a standard value which is preset and with Type you can determine which basis the selection option has. So for orders for orders or samples for samples or just a simple drow down list with comma separated values.
You now integrate the variable defined in this way into the SQL query with e.g.VAR0
.
Attention: If you do not integrate the variable into the query, the selection fields above the SQL report remain, but have no effect on the SQL report.
Variables for the period
To make a time period adjustable, simply integrate the following code into the SQL query at a date field:
BETWEEN
FROMDATE AND TILLDATE
You can then run the SQL report according to your desired time periods.
Integration of variables in URL
If you wold transmit the variables in the url, the url is shown like this:
typ | code | example |
---|---|---|
html | /stats/view/STAT_ID?s=1&var0=_VAR=_&var1=_VAR1_ |
/stats/view/507?s=1&var0=11069%2C11070&var1=test |
/stats/view/STAT_ID/pdf?s=1&var0=_VAR=_&var1=_VAR1_ |
/stats/view/507/pdf?s=1&var0=11069%2C11070&var1=test |
|
csv | /stats/view/STAT_ID/csv?s=1&var0=_VAR=_&var1=_VAR1_ |
/stats/view/507/csv?s=1&var0=11069%2C11070&var1=test |
json | /stats/view/STAT_ID/json?s=1&var0=_VAR=_&var1=_VAR1_ |
/stats/view/507/json?s=1&var0=11069%2C11070&var1=test |
Last change: 27.03.2025
Allgemeines
Einführungsphase
Mitarbeiter
Aufträge
Proben
Probenvorlage
Berichte
Berichtstabellen Editor
Kunden
Kundenzone (optional)
Anlagen
Rechnungen
Parameter
Rechnen mit Parametern
Schnittstellen
Webservice
Prüfpläne / Grenzwerte / Spezifikationen
Dokumentenlenkung
Prüfmittel
Material
Sonstiges
PDF-Vorlagen
Fragen und Antworten
Dateiverwaltung
Auswertungen
Prozesse