Description of the table value functions
4
4.1 batch_GetElementsByBatch_Sorted
Transfer parameter
@batchguid (Unique identifier): GUID of the batch
Returns a list of started objects of a batch in the order they appear in the sequence report
(SIMATIC BATCH standard log) (order: start time, hierarchical). For reasons of performance,
the use of this function is recommended if you need to identify recipe elements of a batch.
Definition
Name Data type Description
ORDINAL Int Number of the element. Determines the order of the elements.
ROOTGUID Unique identifier GUID of the root object (batch, master recipe or library)
POBJID Int ID of the parent of the object
POTID (1) Int Type ID of the parent of the object
OBJID Int ID of the object
OTID (1) Int Type ID of the object
ActivationCounter Int Run of the object
Name nvarchar(255) Name of the object
Description nvarchar(max) Description of the object
StepNo Int Number of the object (contid*10000+termid)
Path nvarchar(255) Hierarchical path to the object
Level Int Level of the object
State (6) Int Status of the object
ExState (7) Int Expanded status of the object
Start Int Status of the object
End datetimeoffset(3) End time of the object
DurationPlanned datetimeoffset(3) Planned duration (in seconds)
DurationActual Int Actual duration (in seconds)
ContinousFlag Int Continue option set
ExecuteInPLC Bit Executed in AS-based mode
MonitoringTime Bit Monitoring time of the object (in seconds)
AllocId Int ID of the allocation
UnitId Int ID of unit
UnitName nvarchar(255) Name of the unit
GateLogic nvarchar(255) Linking logic of the transition conditions
SIMATIC BATCH - Views of the report data V9.0
Programming Manual, 05/2017, A5E38208785-AA 49