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.  

   

WHERE ARE THESE SETTING STORED? 

These settings can be found in a Patricia table called PAT_DMS_SETTINGS. To view a list of entered settings run the below command.

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. 

PAT_DMS_SETTINGS Configuration


I DON’T SEE ALL THE SETTINGS IN MY PAT_DMS_SETTING TABLE. WHY?

All settings in EDMS system have a default value which you can see in the link provided above.

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.

  1. Run the command select * from pat_dms_settings
  2. If the setting parameter is not present, then you need to do an SQL INSERT command.
  3. If the setting parameter is already entered the you want to do an SQL UPDATE command.


HOW TO ADD A SETTING VIA INSERT?

To add a setting to the PAT_DMS_SETTINGS table the first step would be to make sure the setting does not already exist. If it does exists you need to do an UPDATE command.

If it does not exist then proceed with the below.

  1. You need to run an insert script and define the parameter name (DMS_SETTING_KEY) and value (DMS_SETTING_VALUE).

  2. The script would look as follows

    insert into PAT_DMS_SETTINGS(DMS_SETTING_KEY, DMS_SETTING_VALUE)
select 'DMS_SETTING_KEY', 'DMS_SETTING_VALUE'

  3. So a practical example would be the following setting;

I wish to change the behavior on move.copy.default.is.copy

The script will look as follows;

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?

To update a setting to the PAT_DMS_SETTINGS table, the first step would be to make sure the setting does already exist. If it does not exists you need to run an INSERT  command.

If it does exist then proceed with the below.

  1. You need to run an update script and define the parameter name (DMS_SETTING_KEY) and value (DMS_SETTING_VALUE).

  2. The script would look as follows

    update PAT_DMS_SETTINGS
set DMS_SETTING_VALUE='DMS_SETTING_VALUE'
where DMS_SETTING_KEY='DMS_SETTING_KEY'
  3. So a practical example would be the following setting;

I wish to update the behaviour on move.copy.default.is.copy

The script will look as follows;

update PAT_DMS_SETTINGS
set DMS_SETTING_VALUE='false'
where DMS_SETTING_KEY='move.copy.default.is.copy'


OTHER MANDATORY STEPS

When you have updated PAT_DMS_SETTING you always need to restart certain containers in docker.  This is out of scope for this document but the shortened steps listed below.

  1. Launch PUTTY.EXE
  2. Enter the HOST details
  3. CONNECT
  4. Enter the user name and password
  5. Type restart docker nuxeo cb to restart both the nuxeo and case browser container
  6. Your changes will then take effect.
  • No labels