LIMS.eu

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: SQL Basics



For Parameter columns and Variables in SQL reports 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: Export SQL Reports