Solutions
...
Interacting with Litmus Produc...
Adding or Modifying a Tag Item
7 min
use cases to store tag data inside litmus production record database, tags and their device association together with the item's to be stored have to be setup user can do this either by using applications such as microsoft sql server management studio mssql cli this can also be used for building custom solutions based on applications which allow for an odbc connection such as excel c# net python litmus does provide such as custom solution which can be downloaded from our central portal method execute stored procedure prorec tag processtagconfiguration note litmus production record database can act similar to an historian and allows to store data for individual defined tags and their meta data input variables 155,141,239,219,133,114 false true false unhandled content type unhandled content type unhandled content type unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type how to use to insert a tag item, call the stored procedure prorec tag processtagconfiguration using the t sql exec or execute keyword and provide the input variables below is an example using t sql in sql server management studio execute \[le productionrecord] \[dbo] \[prorec tag processtagconfiguration] @tagname = n'isrunning', @devicename = n'l1 machine2 1 mb', @item = n'process value', @itemdesc = n'process value of the tag', @isdecimal = 1, @isinteger = 0, @isstring = 0, @isboolean = 0, @ismeta = 0, @initvalue = null; result the stored procedure will verify that the provided values are correctly formatted and then create any new node, levels and items or modify existing items the result can be read back from the log table prorec misc log below is an example using t sql in sql server management studio select top (100) \[logid] ,\[logtype] ,\[logprocedure] ,\[logentry] ,\[logtime] from \[le productionrecord] \[dbo] \[prorec misc log] where \[logprocedure] = 'prorec tag processtagconfiguration' order by logid desc; with the result returned