Before creating a report, you should briefly sketch the table you want to create so that you know which columns you need.
To create a new SQL Report, click on in the navigation bar: orders ->
SQL report and
Add new SQL report.
First you assign a name for the SQL report and then you can optionally fill the 4 following fields
(optional)
Navigation bar: in which menu of the navigation bar this SQL report should appear.
Orders
Samples
Equipment
(optional) Appears in: In which area this SQL report should appear additionally, so that it can be reached quickly.
Samples detail view and/or samples overview
Order detail and/or order overview
Customers detail view
Specification detail view
Recipes detail view
Dashboard
(optional) Forwarding to: The results of the SQL report are displayed in a tabular form by default. To choose a different representation of the following, make a setting here.
Sample list
Samples results table
Samples result diagram
Order list
Recipe list
Note: If you leave this field blank, other display options are also available in the table display.
(optional) Description: Short description to distinguish from other SQL reports.
SQL query
Enter your SQL query in the following yellow field SQL query. You can use the examples as a guideline or use the web search to find the appropriate SQL command for your analysis. You can find some SQL basics in the following tutorial: Auswertungen SQL-Grundlagen
For Parameterspalten and Variablen in Auswertungen take a look at these two instructions.
With Save your SQl report is saved and will be executed. This should be quick, but may take a little while depending on the complexity of the query.
Note: An error or MySQL syntax error happens often. Mostly a bracket is missing, or a comma is too much or missing.
You can then export the results table as Excel or CSV on the one hand, and display it in sample list or results table on the other.
You can find more options for automatic export in the manual: Auswertungen exportieren
