Solutions
...
Litmus Production Record Datab...
Interacting with Litmus Produc...
Reading out specific Data Model definition - second option
6min
use cases reading out the data model definition can be used to verify what data models do exist and what items and levels are defined this is most useful, when creating a new data model or wanting to modify an existing data model 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 prorec readconfiguration note data models are a hierarchy used to organize and relate production record event data according to isa 88 rules input variables variable name datatype description example @node varchar(50) the name of a root node of a specific data model mandatory! can not be null or empty downtime how to use to read out a specific data model definition, call the stored procedure prorec prorec readconfiguration 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 prorec readconfiguration] @node = n'downtime'; result the function returns a table as result