Venio Console: Archive Handling Level

The Problem

Discrepancy between the count in search result in the search UI and the total documents count in the Project Details UI.

Resolution

We have a control setting with a key called ‘ARCHIVE_HANDLING_LEVEL’. The values for it can be set as 0, 1 or 2
When value is 0, archives are excluded in search.

When value is 1, archives are included in search.

When value is 2, only non-processed, corrupted and password protected archives are included in search.

Therefore, in order to set the archive handling level as desired, please run the following update statement in your project database:

update tbl_pj_projectsetting 
set [value]=<your desired value> where [key] = ‘ARCHIVE_HANDLING_LEVEL’

In order to set the default archive handling level for all projects (effective only for the projects created after this update has been made) please run the following statement in the VenioPCD

 update tbl_pj_controlsetting 
set [value]=<your desired value> where [key] = ‘ARCHIVE_HANDLING_LEVEL’

After updating the tbl_pj_controlsetting in  VenioPCD, the default value for ‘ARCHIVE_HANDLING_LEVEL’ will be the same in tbl_pj_projectsettings for the new projects created after update in tbl_pj_controlsetting of VenioPCD.