SQL Panel

The SQL panel allows you to enter SQL statements to perform queries on current and archive data in the WinCC OA database.

Based on the SQL functions in CONTROL, it is no longer necessary to create a script by hand in order to query data in the database. With the aid of the various tabs on the SQL panel, you can query data by means of the usual SQL statements used in WinCC OA. This panel provides the user with a convenient way of building an appropriate SQL statement for the specific application.

The panel consists of tabs named after the query commands and one tab displaying the results of the query. This allows you to query the database quickly and easily.

Table 1.
Chapter Description
SQL panel, basics Introduction to the SQL panel
Requirements Requirements and opening the panel
All/Alert tab Figure and brief explanation
Select tab Figure and brief explanation
From tab Figure and brief explanation
Remote tab Figure and brief explanation
Where tab Figure and brief explanation
Timerange tab Figure and brief explanation
Sort/Group tab Figure and brief explanation
Data tab Figure and brief explanation
Other functions Description of additional buttons
Practical use of the SQL panel Example of a simple query using the SQL panel

There is an additional detailed description of how to use the respective statements to the right of every tab in the SQL panel.