Siemens SIMATIC PCS 7 - 6 Examples of Links; Introduction; Root Object - Subobjects

Examples of links
6
6.1 Introduction
This chapter provides examples of how the views are linked semantically. There are 3 types
of links.
6.2 Root object - subobjects
The linking of a ROOT object with its lower-level objects is based on the GUID of the root
object.
1. Return all recipe elements of batch x with OGUID = myGUID:
Select * from vRecipeElement where ROOTGUID = myGUID
2. Return all messages of a batch with OGUID = myGUID
Select * from vCDVMessages where ROOTGUID = myGUID
Select * from vRecipeElement where ROOTGUID = myGUID
Example:
ROOT (OGUID) = Object(ROOTGUID)
SIMATIC BATCH - Views of the report data V9.0
Programming Manual, 05/2017, A5E38208785-AA 67