LIMS.eu

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 query report 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 query report 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: