LIMS.eu

You can find the Query Explorer under: Navigation bar → any dropdown menu in the left-hand area → Query Explorer

The AI Explorer allows users to:

• Ask questions in natural language.
• The AI automatically generates the appropriate SQL query.
• The result is clearly displayed and can be expanded if necessary.
• Useful queries can then be saved as query reports and integrated into the dashboard if required.

Functions in AI Explorer

Enter question

• At the bottom of the page, you will find the text input field Enter your question here... in the left-hand area.
• Enter your question in this field.
• Click on the blue Send button (paper airplane icon) to the right of the input field to send your question to the AI.
• Alternatively, you can click on the blue sample question in the middle section.

Result

The result is divided into two areas:

1. AI assistance area (left side of the page)
2. Query area: Results table and SQL editor (right side of the page)

Once the SQL query for your question has been created, the results table will appear in the right-hand section of the page.

• Click on Display SQL Query above the table to open the SQL editor and view the query created by the AI to determine your result.
• If necessary, you can customize the query in the editor or enter additional questions in the AI assistance area to adjust the query.
• To execute the query, click on Show result in the assistance area or on Run query in the SQL editor (in the lower right area of the SQL editor).

You can easily save useful queries.
There are two buttons available for this purpose:

• Add as dashboard element
  Adds this query as a widget to the selected dashboard.
• Save as query report
  Saves the query for later use as a query report.

You will find these buttons above the query result.

For each additional question within a session, the query is adjusted and the AI assistance area is expanded downward.
You can recall previous results by clicking on Show result.

AI assistance area

Shows the following elements:
User question

• Your question is highlighted with a blue background.
• Example: How many samples were created this year?

Textual explanation of how the result was generated

• Below the question, you will find a textual explanation of the SQL query generated by the AI for your question.
• The tables and columns of the database used in the query to generate the result are highlighted.
• Example: The field u_created from the table samples was used to obtain the creation time of the samples for answering the question.

Button bar
Metadata table (eye icon) - The metadata table shows you information such as the number of tokens used, the AI model used, and the processing time.
The AI model used can be set in the system settings.
Copy description (document icon) - To copy the description.
Rate answer (thumb icon) - Use the thumb icons to rate the answers you receive as positive or negative.
Delete response (trash can icon) - To delete the response.

Query area

Shows the SQL query on which the result is based and the result table created with it.

Button bar
The button bar below the text field of the SQL editor offers various interaction and information options.
Templates (clipboard icon) - For accessing saved SQL templates.
Execute query (circle with play icon) - Displays the result of the currently stored SQL query. If you have made changes to the query, you can check the result of your changes.

Related topics: AI Explorer, AI Extension for Import Interfaces, Activate/deactivate AI functions