SQL Panel
The SQL panel allows you to enter SQL statements to perform queries on current and archive data in the WinCC OA database (DB).
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.
| 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.
