Reading out the Application configuration of Litmus Production Record Database

6 min

use cases litmus production record database keeps required settings in an internal table, which can be read by users 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 method run s elect query with view prorec misc getappconfig as from clause how to use to read out the application configuration of litmus production record database, execute a select statement from the view prorec misc getappconfig below is an example using t sql in sql server management studio select \[configitem] ,\[configvalue] from \[le productionrecord] \[dbo] \[prorec misc getappconfig] ; result the view returns a table as result example for a windows installation example for a linux installation understanding the output configuration items which can be changed 267 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type configuration items which can not be changed configitem description changeable? failed trans count \<x> this is an internal value which is created for every data model where \<x> is the data models id the value represents the number of items and is used to facilitate how often to try to reprocess production record events if they failed to process for example because of missing identifiers no