Modify Application Configuration Items
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.
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
Execute Stored Procedure PROREC_Misc_Update_APP_Config.
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 |
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.
Example of modifying several Configuration Items.
The function returns a table with the new value
Example of modifying one Configuration Item.
Example of modifying several Configuration Items.
