Siemens SIMATIC PCS 7 Programming Manual
Process control system simatic batch - views of the report data v9.0
Hide thumbs
Also See for SIMATIC PCS 7:
- System manual (366 pages) ,
- Configuration manual (302 pages) ,
- Manual (286 pages)
Table of Contents
Advertisement
Quick Links
Advertisement
Table of Contents
Related Manuals for Siemens SIMATIC PCS 7
Summary of Contents for Siemens SIMATIC PCS 7
- Page 1 Security information Introduction Description of the views SIMATIC Description of the table value functions Process Control System PCS 7 SIMATIC BATCH - Views of the Description of the enumerations report data V9.0 Examples of links Programming Manual 05/2017 A5E38208785-AA...
- Page 2 Note the following: WARNING Siemens products may only be used for the applications described in the catalog and in the relevant technical documentation. If products and components from other manufacturers are used, these must be recommended or approved by Siemens. Proper transport, storage, installation, assembly, commissioning, operation and maintenance are required to ensure that the products operate safely and without any problems.
-
Page 3: Table Of Contents
Table of contents Security information............................7 Introduction..............................9 Description of the views..........................11 vAction...........................11 vAllocation..........................12 vAllocationCandidate......................12 vBatch............................13 vBatchArchive........................14 vCategory..........................15 vCDVMessage........................15 vChangedItems........................16 vComment..........................17 3.10 vContainer..........................18 3.11 vContainerOnline........................19 3.12 vDataType..........................20 3.13 vDataTypeValue........................20 3.14 vExecutedEsigs........................20 3.15 vExtendedError........................21 3.16 vExtendedErrorState......................22 3.17 vFormula..........................23 3.18 vFormulaCategory........................23 3.19 vInstance..........................24 3.20 vMaterial..........................24 3.21 vMessageExtended........................25... - Page 4 Table of contents 3.29 vOnlineParameterValue......................32 3.30 vOnlineTagExtended......................33 3.31 vOrder............................34 3.32 vOrderCategory........................35 3.33 vParameterDescription......................35 3.34 vParameterRTInfo........................36 3.35 vPCell.............................38 3.36 vRecipeElement........................38 3.37 vRecipeElementOnline......................39 3.38 vRecipeUnitProcedure......................40 3.39 vRecipeOperation........................41 3.40 vProcedure..........................42 3.41 vStateChange........................43 3.42 vSUB............................44 3.43 vTargetObjects........................45 3.44 vTermTrans..........................46 3.45 vTermTransOnline.........................47 3.46 vUoM............................48 Description of the table value functions......................49 batch_GetElementsByBatch_Sorted..................49 batch_GetStandardReport.....................50 batch_GetConditionRows.......................52...
- Page 5 Table of contents 5.13 FormulaState, RecipeState....................59 5.14 Level............................60 5.15 MessageState........................60 5.16 MessageType.........................60 5.17 ObjectType..........................60 5.18 OPDIsQuit..........................62 5.19 OPDActiv..........................62 5.20 RpeState..........................62 5.21 RpeExState..........................63 5.22 RecipeExState........................64 5.23 ScaleFunc..........................64 5.24 SignState..........................64 5.25 StartMode..........................64 5.26 StepCommand........................65 5.27 StepType..........................65 5.28 SubObjectType........................65 5.29 UserConstraints........................66 5.30 UsageID..........................66 5.31 ValueSource...........................66 Examples of links............................67...
- Page 6 Table of contents SIMATIC BATCH - Views of the report data V9.0 Programming Manual, 05/2017, A5E38208785-AA...
-
Page 7: Security Information
In order to protect plants, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art industrial security concept. Siemens’ products and solutions only form one element of such a concept. Customer is responsible to prevent unauthorized access to its plants, systems, machines and networks. - Page 8 Security information SIMATIC BATCH - Views of the report data V9.0 Programming Manual, 05/2017, A5E38208785-AA...
-
Page 9: Introduction
Introduction This document describes views provided in SIMATIC BATCH for the BATCH data in the SQL Server database. The data may be located: ● In the SQL Server instance (INFSERVER) on the BATCH Server PC. In this case, this is data of the objects that have already been logged. - Page 10 Introduction SIMATIC BATCH - Views of the report data V9.0 Programming Manual, 05/2017, A5E38208785-AA...
-
Page 11: Description Of The Views
Description of the views vAction User actions User actions are shown here. User actions are those actions initiated by the user on a batch or batch elements. Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch) ROOTOBJID ID of the root object ROOTOTID (Page 60) -
Page 12: Vallocation
Description of the views 3.2 vAllocation vAllocation Allocations View of unit allocations. Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch, master recipe or library) ROOTOBJID ID of the root object ROOTOTID (Page 60) Type ID of the root object OBJID ID of the allocation OTID (Page 60) -
Page 13: Vbatch
Description of the views 3.4 vBatch Name Data type Description ROOTOTID (Page 60) Type ID of the root object OBJID ID of the candidate OTID (Page 60) Type ID of the candidate POBJID ID of the allocation POTID (Page 60) Type ID of the allocation InstanceId ID of unit... -
Page 14: Vbatcharchive
Description of the views 3.5 vBatchArchive Name Data type Description ActStart datetimeoffset(3) Actual start time of the batch ActEnd datetimeoffset(3) Actual end time of the batch StartMode (Page 64) Start mode of the batch State (Page 55) Int (*) Status of the batch ExState (Page 55) Int (*) Extended status of the batch... -
Page 15: Vcategory
Description of the views 3.6 vCategory Name Data type Description ArchiveTimeStamp datetimeoffset(3) ArchiveDataType nvarchar(32) XML or PDF ArchiveData varbinary(max) vCategory Phase and process tag types View of all phase and process tag types from PCS 7 Engineering. Definition Name Data type Description PCellGUID Unique identifier... -
Page 16: Vchangeditems
Description of the views 3.8 vChangedItems Name Data type Description OS_Server nvarchar(255) Origin of the OS message MsgNumber bigint WinCC message number MsgCounter bigit Consecutive number (OS-specific) as‐ signed by WinCC MsgType 1: Status message 2: Operator message 3: Error message 4: Limit violation message ClassId (Page 56) WinCC message class... -
Page 17: Vcomment
Description of the views 3.9 vComment Name Data type Description POTID (Page 60) Type of the action OBJID ID of the object OTID (Page 60) Type of the object EntryType (Page 56) Type of the object Objectname nvarchar(255) Name of the object Changetype (Page 56) Type of change Oldvalue... -
Page 18: Vcontainer
Description of the views 3.10 vContainer Name Data type Description MsgNumber Bigint Number of the message when transfer‐ ring the batch data. A server prefix can have multiple messages with the same MsgNo. MsgCounter Bigint Sequential ID of the message gener‐ ated by the PCS 7 OS. -
Page 19: Vcontaineronline
Description of the views 3.11 vContainerOnline Name Data type Description UnitRel Unit is released at the end AllocId ID of the allocation UnitId ID of unit ExecuteInPLC Executed in AS-based mode GraphicType tinyint Type of stored graphic (1: png) Graphic varbinary(max) Graphic in BLOB format SFCId... -
Page 20: Vdatatype
Description of the views 3.12 vDataType 3.12 vDataType Data types View of all data types of the process cell. Definition Name Data type Description PCellGUID Unique identifier GUI of the process cell object PCellPartID Part ID of the process cell object OBJID ID of the data type Name... -
Page 21: Vextendederror
Description of the views 3.15 vExtendedError Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch, master recipe, library, formula) ROOTOBJID ID of the root object ROOTOTID (Page 60) Type ID of the root object P2OBJID ID of the higher-level object of the con‐ tainer object P2OTID (Page 60) ID of the higher-level object of the con‐... -
Page 22: Vextendederrorstate
Description of the views 3.16 vExtendedErrorState Name Data type Description P2OTID (Page 60) ID of the higher-level object of the con‐ tainer object POBJID ID of the container object POTID (Page 60) Type ID of the container object OBJID ID of the error OTID (Page 60) Type ID of the error EntryType (Page 56) -
Page 23: Vformula
Description of the views 3.17 vFormula 3.17 vFormula Formula This view contains all the created categories. Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (formula catego‐ ROOTOBJID ID of the root object ROOTOTID (Page 60) Type ID of the root object OGUID Uniqueidentifier GUID of the object (formula) -
Page 24: Vinstance
Description of the views 3.19 vInstance Name Data type Description Description nvarchar(max) Description of the object ModificationDateTime datetimeoffset (3) Last change date of the object 3.19 vInstance Process cell instances View of all process cell instances (PCell, Unit, EMOD, EP, EUP, EOP, EPH, TagCollect). Definition Name Data type... -
Page 25: Vmessageextended
Description of the views 3.21 vMessageExtended Name Data type Description Name nvarchar(255) Name of the material Code nvarchar(16) Code of the material Withdrawn Material has been deleted Description nvarchar(max) Description of the material InputMaterial Input material OutputMaterial Output material 3.21 vMessageExtended Batch messages Extended view of the batch messages. -
Page 26: Vmonitoredobjects
Description of the views 3.22 vMonitoredObjects Name Data type Description UserOperation nvarchar(256) Operator text with operator name and type ID of the reporting object Origin nvarchar(256) Name of the reporting object Message nvarchar(256) Message in text form Area nvarchar(256) Name of the unit. Only for messages within a recipe unit. -
Page 27: Vmodification
Description of the views 3.24 vModification Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch, master rec‐ ipe or library) ROOTOBJID ID of the root object ROOTOTID (Page 60) Type ID of the root object POBJID ID of the higher-level object POTID (Page 60) Type ID of the higher-level object... -
Page 28: Vofflineesigs
Description of the views 3.25 vOfflineEsigs Name Data type Description ROOTOTID (Page 60) Type ID of the root object OGUID Uniqueidentifier GUID of the log entry POBJID ID of the container object POTID (Page 60) Type ID of the container object OBJID ID of the change OTID (Page 60) -
Page 29: Vofflineparametervalue
Description of the views 3.26 vOfflineParameterValue Name Data type Description ClosedExamination This means that if more than one signa‐ ture is required, all signatures must be provided at the same time, in other words, in an open "Sign" dialog box. InputOrderRandom Order that must be maintained in provid‐... -
Page 30: Vofflinetag
Description of the views 3.27 vOfflineTag Name Data type Description HiValue_int High limit of the value RecLoValue_int Low recipe limit of the value RecHiValue_int High recipe limit of the value Value_int Formula for calculating the value LoValue_float float Low limit of the value HiValue_float float High limit of the value... -
Page 31: Vonlineconditions
Description of the views 3.28 vOnlineConditions Name Data type Description P2OTID (Page 60) ID of the higher-level object of the con‐ tainer object PrameterId ID of the associated parameters (vPar‐ ameterDescription view) AllocId ID of the allocation CategoryId ID of the unit type or of the block type (view: vCategory) 3.28 vOnlineConditions... -
Page 32: Vonlineparametervalue
Description of the views 3.29 vOnlineParameterValue 3.29 vOnlineParameterValue Parameter data of the batches This view contains the parameter data of the batches. Only parameters of the batches and the recipe elements that have already been started (only the last parameter set per run) are provided. -
Page 33: Vonlinetagextended
Description of the views 3.30 vOnlineTagExtended Name Data type Description sp_locname nvarchar(255) Setpoint (location name) asp_locname nvarchar(255) Actual-setpoint (location name) av_locname nvarchar(255) Process value (location name) sp_matname nvarchar(255) Setpoint (material name) sp_matcode nvarchar(255) Setpoint (material code) asp_matname nvarchar(255) Actual-setpoint (material name) asp_matcode nvarchar(255) Actual-setpoint (material code) -
Page 34: Vorder
Description of the views 3.31 vOrder Name Data type Description ArchiveName nvarchar(255) Name of the archive (system archive, etc.) TagName nvarchar(255) Name of variables TagPath nvarchar(max) Runtime path of the process tag MinTagValue Float Minimum value MaxTagValue Float Maximum value UoMId ID of the unit of measurement of the process tag... -
Page 35: Vordercategory
Description of the views 3.32 vOrderCategory 3.32 vOrderCategory Order categories This view shows the available order categories. Definition Name Data type Description OGUID Uniqueidentifier GUID of the object (order category) OBJID ID of the object OTID (Page 60) Type ID of the object Name nvarchar(255) Name of the order category... -
Page 36: Vparameterrtinfo
Description of the views 3.34 vParameterRTInfo Name Data type Description ActvalProt Process value: Reserved for user data ActValCol Production instruction property activa‐ ted in the engineering. Withdrawn Object has been deleted 3.34 vParameterRTInfo Parameter data of the batches Supplies all setpoints and process values of all parameters that either: ●... - Page 37 Description of the views 3.34 vParameterRTInfo Name Data type Description DataTypeId ID of the data type DataTypeName nvarchar(255) Name of the data type UoMId ID of the technical unit of measure UoMName nvarchar(255) Name of the technical unit of measure HighValue Float High limit of the value...
-
Page 38: Vpcell
Description of the views 3.35 vPCell Name Data type Description asp_prot Actual-setpoint: Reserved for user data (actual-setpoint) av_prot Reserved for user data (process value) See also ValueSource (Page 66) 3.35 vPCell Process cells View of the existing Batch process cells. Definition Name Data type... -
Page 39: Vrecipeelementonline
Description of the views 3.37 vRecipeElementOnline Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch, master rec‐ ipe or library) ROOTOBJID ID of the root object ROOTOTID (Page 60) Type ID of the root object POBJID ID of the higher-level object POTID (Page 60) Type ID of the higher-level object... -
Page 40: Vrecipeunitprocedure
Description of the views 3.38 vRecipeUnitProcedure Definition Name Data type Description ROOTGUID Uniqueidentifier GUID of the root object (batch, master recipe or library) POBJID ID of the higher-level object POTID (Page 60) Type ID of the higher-level object ParentActivationCounter Run of the parent of the object OBJID ID of the object OTID (Page 60) -
Page 41: Vrecipeoperation
Description of the views 3.39 vRecipeOperation Name Data type Description Name nvarchar(255) Name of the object Description nvarchar(max) Description of the object StepNbr Number of the object (contid*10000+ter‐ mid) State (Page 62) Status of the container ExState (Page 63) Expanded status of the container Start datetimeoffset(3) Start time of the container... -
Page 42: Vprocedure
Description of the views 3.40 vProcedure Name Data type Description Description nvarchar(max) Description of the object StepNbr Number of the object (contid*10000+ter‐ mid) State (Page 62) Status of the container ExState (Page 63) Expanded status of the container Start datetimeoffset(3) Start time of the container datetimeoffset(3) End time of the container... -
Page 43: Vstatechange
Description of the views 3.41 vStateChange Name Data type Description ScaleFunc (Page 64) Modification of the duration StartMode (Page 64) Start mode of the batch AutomaticVersioning System-aided versioning MajorVersion Major version, with system supported versioning MinorVersion Minor version, with system supported versioning ModificationDateTime datetimeoffset(3) -
Page 44: Vsub
Description of the views 3.42 vSUB Name Data type Description TimeStamp Datetimeoff‐ Time stamp of the status change. Exclusively as UTC time set(3) stamp. Name nvarchar(255) Name of the object Description nvarchar(max) Description of the object (batch or recipe element) StepNo Step number of the object (ContId*10000+TermId) or for tech‐... -
Page 45: Vtargetobjects
Description of the views 3.43 vTargetObjects Name Data type Description Start datetimeoffset(3) Start time of the container datetimeoffset(3) End time of the container DurationPlanned Planned duration in seconds DurationActual Actual duration in seconds MonitoringTime Monitoring time in seconds OverwriteDuration The runtime calculated by the system can be changed or overwritten ScaleFunc (Page 64) Modification of the duration... -
Page 46: Vtermtrans
Description of the views 3.44 vTermTrans 3.44 vTermTrans Terminals and transitions This view shows the available terminals (RF, command step, equipment operation, operator instruction, library reference) and transitions. It is a specialization of the vRecipeElement view. Definition Name Data type Description ROOTGUID Uniqueidentifier... -
Page 47: Vtermtransonline
Description of the views 3.45 vTermTransOnline Name Data type Description StepCommand (Page 65) smallInt Command FilterState smallInt Filter set AllMonitored smallint All possible target objects within the moni‐ toring are listed. GateLogic nvarchar(255) Linking logic of the transition conditions SFCID Unique ID for the element Terminal or Transition 3.45... -
Page 48: Vuom
Description of the views 3.46 vUoM 3.46 vUoM Physical units View of all physical units of the transferred process cells. Definition Name Data type Description PCellGUID Uniqueidentifier GUI of the process cell object PCellPartID Part ID of the process cell object OBJID ID of the unit of measure OTID (Page 60) -
Page 49: Description Of The Table Value Functions
Description of the table value functions 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. -
Page 50: Batch_Getstandardreport
Description of the table value functions 4.2 batch_GetStandardReport batch_GetStandardReport Transition parameter 1. @lcid (integer): Language ID (1031: German, 1033: English, etc.) 2. @batchguid (Unique identifier): GUID of the batch. This function returns the data that is displayed in the main report of a batch. There are two types of data in the returned data records: ●... - Page 51 Description of the table value functions 4.2 batch_GetStandardReport Name Data type Description cmd_filter Status that the respective recipe phase must have in runtime for a corresponding command to be passed State Status of the object ExState Expanded status of the object Flags Internal ContinousFlag...
-
Page 52: Batch_Getconditionrows
Description of the table value functions 4.3 batch_GetConditionRows batch_GetConditionRows Transition parameter: 1. @xmlParam (nvarchar(max)): Conditions in XML format 2. @batchguid (Uniqueidentifier): GUID of the batch 3. @pcellguid (Uniqueidentifier): GUID of the process cell The passed XML format of the conditions of a transition are represented in tabular form. Definition Name Data type... -
Page 53: Description Of The Enumerations
Description of the enumerations ActionState Description Inactive Not supported Refused In progress Closed Error Aborted Held Waiting for signature AllocStrategy Description Preferred unit The longest out of use Operator selection Process parameters ActionType Description Start step Pause step (after step) Hold step (immediately) Abort step Resume step... - Page 54 Description of the enumerations 5.3 ActionType Description Changing a unit Changing a unit Adding parameters Delete parameter Open master recipe file Delete batch Archive batch Cancel batch Release batch Lock batch Start batch Pause batch after active step Hold batch immediately Resume batch Abort batch Close batch...
-
Page 55: Batchexstate
Description of the enumerations 5.4 BatchExState Description Stop step Abort batch (emergency) Abort step (emergency) Stop step (except for running equipment phases) Change batch quantity BatchExState Description Error BatchExState_PARTICIPLE_PRESENT Archived Error + Archived Archiving Closed Closing Closed + Archived test Sub-element blocked Sub-element waiting Sub-element active... -
Page 56: Classid
Description of the enumerations 5.6 ClassId Description Paused after step Held Aborted Completed Stopped Testing release Release invalid ClassId Description Process control error (AS, OS) Operator prompt Operator message Status message ChangeType Description Setpoint Process value Duration Unit allocation Allocation strategy Candidate Allocation parameter Start allocation... -
Page 57: Errorreason
Description of the enumerations 5.9 ErrorReason Description Order Batch Material Unit UnitClass Container Transition Terminal Parameter Unit allocation Candidate Extended error message Change (ChangedItem) ErrorReason Description Undefined error state Timeout No valid unit candidates found Writing data to the database failed Failed to create a new process cell Error in transition condition Error logging on at the condition variable... -
Page 58: Errorstate
Description of the enumerations 5.10 ErrorState Description AS does not have enough free DBs Equipment not allocated Not all AS data blocks could be reallocated Error loading to the AS Allocation of unit not possible Recipe element is waiting for unit allocation Start failed Completion failed Continuous operation failed... -
Page 59: Errorclass
Description of the enumerations 5.11 ErrorClass Description Removed Aborted Pending and acknowledged Outgoing and acknowledged 5.11 ErrorClass Description Undefined error No errors Serious error Error Warning Information Error in child object 5.12 EventNotifyType Description Status change Setpoints written Process values read 8192 Setpoint change 5.13... -
Page 60: Level
Description of the enumerations 5.14 Level 5.14 Level Description Process cell Unit Equipment module Equipment procedure Equipment unit procedure Equipment operation Equipment phase Collection of actual values in the process cell with TAG_COLLECT (collection of equipment tags) 5.15 MessageState Description Incoming Outgoing Acknowledged... - Page 61 Description of the enumerations 5.17 ObjectType Description Data type Value of the data type (e.g. false, true) Formula Batch instance Change entry in log Order category Batch process cell Description of the parameters Enumeration (Enum) Equipment reference Floating point number Integer Material String...
-
Page 62: Opdisquit
Description of the enumerations 5.18 OPDIsQuit Description Recipe operation OPD_RPH (OPD at RPH level) OPD_ROP (OPD at ROP level) NOP (no operation) Wait step Library reference Parameter step Acknowledgeable alarms Non-acknowledgeable alarms User action System action Type of changes of a user action Type of changes of a system action 5.18 OPDIsQuit... -
Page 63: Rpeexstate
Description of the enumerations 5.21 RpeExState Description Completing Completed Continuous mode Aborted Aborting Stopped Stopping Held Holding Resuming Paused after step Pausing after step Switched 5.21 RpeExState Possible additional status expansions of a recipe element. Description 0x00000001 Error 0x00000004 Command is being executed 0x00000008 Breakpoint 0x00000010... -
Page 64: Recipeexstate
Description of the enumerations 5.22 RecipeExState Description 0x01000000 Subobject held or canceled 0x02000000 Subobject waiting 0x04000000 Subobject requires operator action 0x08000000 Child object in error 0x20000000 Allocation error 0x40000000 Pause 5.22 RecipeExState Description No ExStatus Error Transitional status Archived Test release 1024 Electronic signature required 5.23... -
Page 65: Stepcommand
Description of the enumerations 5.26 StepCommand Description Cyclically driven. Is not available in the batch dialog. Event driven. Is not available in the batch dialog. 5.26 StepCommand Description Start Stop Abort Hold (immediately) Pause (after step) Resume Complete Reset Set breakpoint Remove breakpoint Resume breakpoint Reset and start... -
Page 66: Userconstraints
Description of the enumerations 5.29 UserConstraints Description 1024 Equipment operation (EOP) 4096 NOP (no operation) 8192 Wait 32768 Continuous 5.29 UserConstraints Description Static candidate selection Dynamic candidate selection via conditions Without restriction 5.30 UsageID Description PP (process parameter) PI (input material) PO (output material) TAG (variable) CS (control strategy) -
Page 67: Examples Of Links
Examples of links Introduction This chapter provides examples of how the views are linked semantically. There are 3 types of links. Root object - subobjects The linking of a ROOT object with its lower-level objects is based on the GUID of the root object. - Page 68 Examples of links 6.2 Root object - subobjects Figure 6-1 Structure of a hierarchical batch SIMATIC BATCH - Views of the report data V9.0 Programming Manual, 05/2017, A5E38208785-AA...
-
Page 69: Direct Recipe Element - Subobjects
Examples of links 6.3 Direct recipe element - subobjects Figure 6-2 Structure of a flat batch Direct recipe element - subobjects A recipe element is linked with its immediate subobjects by means of ID, Type and ActivationCounter relationships. Return all children of a recipe element with ROOTGUID= myGUID, POBJID = myPOBJID, POTID=myPOTID, OBJID=myOBJID, OTID=myOTID, ActivationCounter=myAC and ParentActivationCounter= myPAC. -
Page 70: Recipe Element - Properties
Examples of links 6.4 Recipe element - properties Recipe element - properties A recipe element is linked with its properties by means of ID, Type and ActivationCounter (or start and end time) relationships. Figure 6-3 vRecipeElement - properties link SIMATIC BATCH - Views of the report data V9.0 Programming Manual, 05/2017, A5E38208785-AA... - Page 71 Examples of links 6.4 Recipe element - properties 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...
- Page 72 Examples of links 6.4 Recipe element - properties messages.TimeStamp <= myEndTime and messages.TimeStamp >= myStartTime 4. Return all messages of a terminal term with ROOTGUID= myGUID, POBJID = myPOBJID, POTID=myPOTID, OBJID=myOBJID, ExStartTime=myStartTime and ExEndTime=myEndTime. select * from vCDVMessages as messages where messages.ROOTGUID = myGUID and messages.POBJID = myOBJID and messages.POTID = 28 and messages.P2OBJID = myPOBJID and...
-
Page 73: Index
Index ActionState, 53 ObjectType, 60, 61, 62 ActionType, 53, 54, 55 OPDActiv, 62 AllocStrategy, 53 OPDIsQuit, 62 batch_GetElementsByBatch_Sorted, 49 Process Historian, 9 batch_GetStandardReport, 50, 52 BatchExState, 55, 65 BatchState, 55, 56 Recipe element, 38 Recipe element - properties, 70 RecipeExState, 64 ChangeType, 56 RecipeState, 59 ClassId, 56... - Page 74 Index vContainer, 18 vContainerOnline, 19 vDataType, 20 vDataTypeValue, 20 vExecutedEsigs, 20 vExtendedError, 21 vExtendedErrorState, 22 vFormula, 23 vFormulaCategory, 23 vInstance, 24 vMaterial, 24 vMessageExtended, 25 vModification, 27 vMonitor, 26 vMonitoredObjects, 26 vOfflineEsigs, 28 vOfflineParameterValue, 29 vOfflineTag, 30 vOnlineConditions, 31 vOnlineParameterValue, 32 vOnlineTagExtended, 33 vParameterDescription, 35 vParameterRTInfo, 36...