Siemens SIMATIC PCS 7 - Page 71

1. Return all comments of a recipe element with ROOTGUID= myGUID, POBJID = myPOBJID,
POTID=myPOTID, OBJID=myOBJID, OTID=myOTID, ActivationCounter=myAC and
ParentActivationCounter= myPAC.
select * from vComment as cmnt where
cmnt.ROOTGUID = myGUID and
cmnt.POBJID = myOBJID and cmnt.POTID = myOTID and
cmnt.P2OBJID = myPOBJID and cmnt.POTID = myOTID and
cmnt.ActivationCounter = myAC
Example:
Object(ROOTGUID) = Cmnt(ROOTGUID)
Object (OBJID, OTID) = Cmnt (POBJID, POTID)
Object (POBJID, POTID) = Cmnt (P2OBJID, P2OTID)
Object (ActivationCounter) = Cmnt (ActivationCounter)
2. Return all actions of a recipe element (including changes) with ROOTGUID= myGUID,
POBJID = myPOBJID, POTID=myPOTID, OBJID=myOBJID, OTID=myOTID,
ExStartTime=myStartTime and ExEndTime=myEndTime.
select act.actiontype, act.UserLogin, act.ExecutionHostname, act.State
changeditem.ChangeType, changeditem.Objectname, changeditem.Oldvalue
changeditem.NewValue
from Action as act LEFT OUTER JOIN ChangedItem as changeditem
on
(act.[OBJID] = changeditem.POBJID AND act.[OTID] = changeditem.POTID and
act.[POBJID] = changeditem.P2OBJID AND act.[POTID] = changeditem.P2OTID and
act.[P2OBJID] = changeditem.P3OBJID AND act.[P2OTID] = changeditem.P3OTID
and
act.ROOTGUID = changeditem.ROOTGUID)
where
act.ROOTGUID = myGUID and
act.POBJID = myOBJID and act.POTID = myOTID and
act.P2OBJID = myPOBJID and act.POTID = myOTID and
act.ExecutionTimeStamp <= myEndTime and act.ExecutionTimeStamp >=
myStartTime
3. Return all messages of a container with the following data: ROOTGUID= myGUID, POBJID
= myPOBJID, POTID=myPOTID, OBJID=myOBJID, ExStartTime=myStartTime and
ExEndTime=myEndTime. Because batch data management (CDV) only uses the main object
types Batch (OTID=3), Container (OTID=37) or Terminals (OTID=28), the OTID is explicitly
specified.
select * from vCDVMessages as messages where
messages.ROOTGUID = myGUID and
messages.POBJID = myOBJID and messages.POTID = 37
Examples of links
6.4 Recipe element - properties
SIMATIC BATCH - Views of the report data V9.0
Programming Manual, 05/2017, A5E38208785-AA 71