Basics SQL in Control

The database functions enable you to quickly carry out value queries on data points and elements. It is also possible in WinCC OA to create value queries with the SQL-Panel (for more information, see also the chapter Basics SQL-Panel).

WinCC OA provides functions that allow detailed querying of individual parts of data points. The results returned as data fields can be filtered and processed, for example, sort, add, search for minimum and others.

Keywords for data points

Data points in WinCC OA show the following structure:

System:datapoint.element:config.detail.attribute

The names for the individual levels (identifiers) are in part freely selectable in WinCC OA. On account of the freedom of naming, a unique assignment between a level and a name is not possible. For this reason, there are predefined keywords for addressing the individual levels:

Table: Keywords for WinCC OA

_SYS system level
_DP data point level
_EL element level
_KF config level
_DT detail level
_AT attribute level
_DPT data point type
_ALIAS alias (query only via WHERE keyword supported)
_COMMENT comment (from Resources::ParamLang - the language of the comment cannot be selected; query only via WHERE keyword supported)
_ELC element type as Control constant (DPEL_xxx)
_LEAF selects only leaf elements

For general reasons, there are also keywords for the first three levels in this table. However, the selection in these levels should already be made at wildcard level. Although the address "*:*;" is theoretically possible (simply everything in all systems) it is not advisable to use it. The evaluation of these keywords always relates to the entire line (that is to the FROM part of the query).

Chapter Description
Basics SQL in Control Introduction SQL in Control
Control functions for SQL Links to the functions that are needed for querying the WinCC OA database
Data management Data management in WinCC OA
Wildcards Explaining Wildcards and examples
Wildcards in the element identifier Using wildcards for data point elements
Queries Structure of the Query-commands and examples
SQL keywords Different query-commands and functionality with SQL-queries (for example MIN, MAX, TIMERANGE)
Basics SQL-Panel As from WinCC OA version 2.11.1, the SQL-Panel simplifies the process of creating value queries
Examples Examples for SQL-queries with current statements and Control functions
Tips and tricks Hints for using SQL in CONTROL
Glossary Important concepts and shortcuts
Summary and continuation to other chapters connected with SQL in Control Links to other chapters