Data management
The saved data in WinCC OA can be divided into:
-
Current data
-
Archived data
-
Current messages
-
Archived messages
Management of the current data and messages takes place in the event manager, the archived data and messages are saved by the data manager. The different elements of the database must also be addressed accordingly in order to obtain the required information.
Table: Querying current data
| Current values | |
|---|---|
| Data |
dpQueryConnect("SELECT... _online.._value ..." ) dpQuery("SELECT... _online.._value ..." ) |
| Messages |
dpQueryConnect("SELECT ALERT... _alert_hdl..value ..") dpQuery("SELECT ALERT... _alert_hdl..value ...") |
Table: Querying archived data
| Archived values | |
|---|---|
| Data | dpQuery("SELECT... _online.._value ...TIMERANGE" ) |
| Messages | dpQuery("SELECT ALERT... _alert_hdl..value ...TIMERANGE." ) |
