Answer:
In the EDMS system we have settings that affects how the EDMS system behaves. Think of these settings similar to the BC values found in Maintenance.
...
| Code Block | ||
|---|---|---|
| ||
select * from pat_dms_settings |
...
The results will show the setting name (DMS_SETTING_KEY) and the actual value (DMS_SETTING_VALUE).
...
WHAT VALUES ARE AVAILABLE TO USE?
A list of all values can be found in the link below.
https://doc.practiceinsight.io/display/DMS/PAT_DMS_SETTINGS + Configuration
I DON’T SEE ALL THE SETTINGS IN MY PAT_DMS_SETTING TABLE. WHY?
...
This default value is applied automatically and will not appear in the PAT_DMS_SETTING table initially. We add a value to PAT_DMS_SETTING only if we wish to overwrite the default value.
...
HOW DO I ADD A SETTING?
To add a setting first check if it’s not already entered in PAT_DMS_SETTING.
- Run the command select * from pat_dms_settings
- If the setting parameter is not present, then you need to do an SQL INSERT command.
- If the setting parameter is already entered the you want to do an SQL UPDATE command.
HOW TO ADD A SETTING VIA INSERT?
...
| Code Block | ||
|---|---|---|
| ||
insert into PAT_DMS_SETTINGS(DMS_SETTING_KEY, DMS_SETTING_VALUE) select 'move.copy.default.is.copy', 'true' |
...
HOW TO ADD A SETTING VIA UPDATE?
...