Solutions
...
Interacting with Litmus Produc...
Reading Tag Meta Data Transposed with UTC timestamp
7 min
use cases returning tag meta data recorded by litmus production record database through the use of these select statements can be used for example by any visualization platform which allows to integrate with mssql like; grafana powerbi tableau further can these queries be used by any other application which allows for an odbc connection such as excel c# net python r they can also be part of a larger stored procedure developed by users with t sql by default, litmus production record stores tag items as rows and not individual columns there can be cases where users may want to transpose the default result table to turn tag items into columns for this, litmus production record database provides a prepared way method run s elect query against the table ##transposetagmetadata after executing the stored procedure prorec tag gettransposedtagmetadatautc 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 unhandled content type unhandled content type unhandled content type false unhandled content type unhandled content type unhandled content type unhandled content type 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 how to use to query transposed tag data, execute the stored procedure prorec tag gettransposedtagmetadatautc first providing all the required inputs first followed by a select statement against the table ##transposetagmetadata below is an example using t sql in sql server management studio exec \[le productionrecord] \[dbo] \[ prorec tag gettransposedtagmetadatautc] @starttime = '2022 10 01 00 00 00 000' select from ##transposetagmetadata; result the function returns a table as result additional options it is possible to reduce the number of columns returned by the select statement below is an example using t sql in sql server management studio exec \[le productionrecord] \[dbo] \[\[dbo] \[ prorec tag gettransposedtagmetadatautc] @starttime = '2022 10 01 00 00 00 000' select tag, high high limit from ##transposetagmetadata; this will reduce the number of columns returned to only the two selected