Variables in SQL reports

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
pdf /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