:warning: Release Information

This release replaces the temporal tables plugin that has been used to fill the history tables in the database. The replacement takes place during the deployment of the backend. In preparation, the following SQL needs to be executed before deploying the release on the SORMAS database using the postgres user:

-- versioning function will be replaced during server backend startup
ALTER FUNCTION public.versioning() OWNER TO sormas_user;

After the successful deployment, you can run the following SQL to get rid of the no longer used extension:

-- needed because `ALTER FUNCTION ... NO DEPENDS ON EXTENSION` is not possible in Postgres 10 and below
DELETE FROM pg_depend
WHERE deptype = 'e'
  AND refobjid = (SELECT oid FROM pg_extension WHERE extname = 'temporal_tables')
  and objid = (SELECT oid FROM pg_proc WHERE proname = 'versioning');

DROP EXTENSION IF EXISTS temporal_tables;

New User Rights

• EXTERNAL_SURVEILLANCE_SHARE and EXTERNAL_SURVEILLANCE_DELETE: Control whether a user role can share data with and delete data from an external surveillance tool (right now only relevant for German systems connected to Survnet); not assigned to any user role by default.

Changelog

New Features

Web Application

• Dashboard: Added a basic samples dashboard that will be extended in future releases (#10721)

Improvements

Web Application

• General: Added a batching mechanism to the "Edit" bulk actions in all directories to avoid timeouts (#10461)
• Persons: Introduced an event participant merging mechanism to person merging if the merging process would result in duplicate event participants in the same event (#11360)
• Contacts: Significantly improved the performance of the merge contacts view by introducing a limit to the amount of displayed duplicates (#11469)
• Users: Added user rights to share and delete data to/from an external surveillance tool (#8926)

Changes

Web Application

• Dashboard: Renamed "Test results" to "Final laboratory results" on surveillance dashboard (#11415)
• S2S: Enabled the delete button for read-only entities so that entities that have been shared can now be removed from the system (#11482)

Bugfixes

Web Application

• Fixed an error when trying to display duplicates in the merge duplicate cases view (#11544)
• Fixed duplicate person detection potentially suggesting unrelated persons if the entered name matched a UUID or external ID (#11527)
• Fixed responsible region and district of associated cases missing from detailed sample export (#11398)

Technology

• Updated Keycloak to 21.0.1 (#10387)
• Replaced the temporal tables Postgres extension with a individual PL/pgSQL function (#10260)
• Replaced BeanTest with CDI-Test (#10074)

Documentation

• Updated the Troubleshooting guide with more information on how to analyze and solve performance problems (#11467)