Page Comparison

Outside of the scenarios described above, the system solution to updating stale data is to enable the task_directory_person_refresh_trigger and set for a time to execute the refresh process as described above.  This should only need to be done one time as the external person sync process should trigger a refresh of the view.  Alternatively, the materialized views can be updated directly.  There is a risk that the Caseload and Search will not work while the database processes are executing.  The following queries could be used with the caution.

• PG: select REFRESH_MV_DIRECTORY_PERSON()

• SQL: exec REFRESH_MV_DIRECTORY_PERSON

• PG: select REFRESH_MV_DIRECTORY_PERSON_BLUE()

• SQL: exec REFRESH_MV_DIRECTORY_PERSON_BLUE