Gateway tag change script:
‘’’
if newValue.value:
#Get the name of the tag that called this script
Tag_Name = event.getTagPath().getItemName()
'# Tag_Name = tag.name
'# Set the Parameters to pass to the Named Query
InductColumn = Tag_Name
t1 = system.date.now()
currentDateTime = system.date.format(t1,‘yyyy-MM-dd HH:mm:ss’)
'# Put the Parameters in a python dictonary
params = {“param1”:InductColumn, “param2”:currentDateTime}
'# Set the #transactions to be serialized
'# TxId = s#ystem.db.beginTransaction("",8)
'# Debug
logger = system.util.getLogger(‘myLogger’)
logger.info (str(param1))
'# print str(params)
‘# Call the query
system.db.runNamedQuery(A_Stats, “dockDoorUpdate”, params)
‘’’’
Named Query:
