SORMAS-Project Files

Important: This release adds a lot of indexes to the database to improve the overall performance of the system. If you have a lot of data in your database, it is very likely that adding these indexes will take quite some time, and this could lead to timeouts during the server update. We strongly recommend to manually execute the SQL code attached to this release (sormasIndexes.sql) in the database before doing the release in order to avoid any problems during server update.

Important: This release re-introduces the server property country.name which was deprecated before. This property is used to determine which country the server is used in, which will pre-fill the new country field in locations. Please make sure to update this property when updating your server to this version.

New Features

• Added a person directory that allows to directly search for persons and access all their cases, contacts and event participants (#2108)
• Added a new Community Officer user role (#4290)
• User roles can now be deactivated in the database by adjusting the "enabled" property of the UserRoleConfig table (#3716)
• [Web] Added Surveillance Reports to cases and an associated feature configuration (#4282)
• [Web] Added activities as case after infection to the epidemiological data section of cases (#4163)
• [Web] Added an event participant import (#3426)
• [Web] Users on community and health facility level can now access the web application (#1960)

Improvements

• Added "Report date" to pathogen tests (#4363)
• Added "Reason for hospitalization" to cases (#4187)
• Added "Not done" as a new final laboratory result for samples (#4219)
• Added "Country" to location details (#2994)
• Added a new "Reinfection" property to cases (#3831)
• Added "Case identification source" to cases (#3420)
• Added new fields to specify the reason why a case was classified as not a case for German systems (#3419)
• Added a server property to disable audit logging of which properties have been changed when entities are updated (#3479)
• Added a new community facility reporting type value for German systems (#3417)
• Added a new field to cases specifying whether the case perso has donated blood or organs during the last six months for German systems (#3414)
• [Web] Imports and exports now use the same format, which allows users to do a detailed export and then use the same file for a subsequent import (#3453)
• [Web] Imports now not only recognize the technical enum value but also their captions in the user language (e.g. "Confirmed case" instead of "CONFIRMED") (#3455)
• [Web] Added a lot of indexes to improve the overall performance of the system (#4307)
• [Web] Refactored the automatic generation/check of epid numbers to only run on systems where they are actually used (#4305)
• [Web] Improved the speed of the case completeness calculation (#4304)
• [Web] Added a feature configuration for the usage of external symptom journals (#4306)
• [Web] Improved query to retrieve campaign diagram data to prevent SQL injections (#4440)
• [Web] Restricted the allowed HTML tags in event actions for security reasons (#4435)
• [Web] Added typing ID to the direct pathogen test creation when creating a sample (#4301)
• [Web] Added filters for event source and personal information of event participants to the event directory (#2619)
• [Web] Added an option to generate events to the developer options (#4185)
• [Web] Epid number is now properly hidden in all forms and grids for German and Swiss instances (#3629)
• [ReST] Added an interface to retrieve all surveillance reports for a list of cases (#4426)
• [ReST] Added (a pretty tolerant) UUID validation to make sure that no incorrect UUIDs are pushed to SORMAS (#4433)
• [SORMAS2SORMAS] Added a filter to show cases/contacts received by or shared with other health departments to the respective directory (#4203)
• [DEMIS2SORMAS] Users can now create or select contacts and event participants as well as select samples and pathogen tests when processing lab message (#4058)
• [DEMIS2SORMAS] Users now see proper error messages when there are errors in the DEMIS adapter (#4017)

Changes

• [SORMAS2SORMAS] Introduced a property that allows to remove the external token from transferred data to avoid duplicate tokens (#4413)

Bugfixes

• Fixed potential problems with certain strings not being properly translated when using a different language than the server language (#4403)
• Added missing validation to vaccination date fields (#4276)
• [Web] Fixed merging duplicate cases with exposures leading to the same location being used in the active and in the deleted exposure and added an SQL script that solves this problem on servers where it already happened (#4338)
• [Web] Fixed potential performance problems with the new contact counts in the event directory (#4325)
• [Web] Fixed some usually mandatory properties not being mandatory in the line listing popup (#4390)
• [Web] Fixed users not being able to select a source case when creating a contact for an event participant that already had a resulting case (#4380)
• [Web] Fixed an error when trying to filter the sample directory by the associated entities (#4377)
• [Web] Fixed an error when trying to sort the event actions directory by risk level, reporting user or responsible user (#4375)
• [Web] Fixed an error when filtering the case directory by case origin (#4354)
• [Web] Fixed a problem when trying to add information of a contact case to generated documents (#4455)
• [Web] Person information in generated documents can now be accessed without the need to specify the root entity to avoid too long field names (#4447)
• [Web] Fixed search field sometimes deleting letters that have been typed in before applying the filters (#3877)
• [Web] Fixed wrong HTML sanitizer being used (#4438)
• [Web] Fixed CSV import templates sometimes not being generated in UTF-8 (#4322)
• [Web] Removed duplicate contact identification source column in detailed contact export (#4289)
• [Web] Fixed date of outcome missing in detailed case export (#4214)
• [Web] Fixed an error when adding a pathogen test with a CQ value while creating a sample (#4125)
• [Web] Fixed some styling problems of tables (e.g. exposures, addresses, previous hospitalizations) (#4110)
• [Web] Fixed admin surveillance supervisors being unable to bulk-delete samples (#4087)
• [Web] Fixed some unnecessary dependencies in the developer options to create cases and contacts (#3337)
• [App] Fixed date validation failing when start and end dates were at the same day in some instances (#4402)
• [App] Fixed source of vaccination information displaying an empty list (#4285)
• [App] Fixed prohibition to work end date for cases rejecting future dates (#4207)
• [App] Fixed facility details being displayed under wrong circumstances for some events (#4094)
• [App] Fixed type of place details not being mandatory when selecting "Other" as type of place (#4092)
• [SORMAS2SurvNet] Fixed displaying a success message even if bulk-sending cases to SurvNet fails (#4401)
• [DEMIS2SORMAS] Fixed lab message HTML overlapping with sample creation form (#4291)
• [SORMAS-SB] Fixed wrong property being used when communicating with PIA (#4407)

Technology

• Added a user synchronisation at server startup to allow to migrate users on running systems to Keycloak (#4409)
• Added a script that can be used to delete cases and contacts from the database (#4156)
• Added missing unique constraint for the UUID column of documents (#3661)