Modify Application Configuration Items

use cases litmus production record database allows users to modify certain application configuration items used by the application to review which configuration items can be modified, please review reading out the application configuration of litmus production record database docid\ evlxiglsvxjkjcqsgf2pp user can modify configuration items either by using applications such as microsoft sql server management studio mssql cli or 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 execute stored procedure prorec misc update app config input variables variable name datatype description example @appconfigitems varchar(8000) a single config item or a comma separated list of config items to be modified mandatory! can not be null or empty days to keep prorec days to keep prorec,days to keep tag @appconfigitemvalues varchar(8000) a single value for a single config item or a comma separated list of values note the position in the comma separated list has to match with the list from the input variable @appconfigitems mandatory! can not be null or empty 100 100,75 how to use to modify one or several configuration item(s), call the stored procedure prorec misc update app config 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 example of modifying one configuration item execute \[le productionrecord] \[dbo] \[prorec misc update app config] @appconfigitems = n'days to keep log', @appconfigitemvalues = n'2'; example of modifying several configuration items execute \[le productionrecord] \[dbo] \[prorec misc update app config] @appconfigitems = n'days to keep prorec,days to keep tag', @appconfigitemvalues = n'100,75'; result the function returns a table with the new value example of modifying one configuration item example of modifying several configuration items