SORMAS-Project Files

IMPORTANT NOTICE This update introduces a performance problem in the case directory when the case follow-up feature is used (visits for cases). To solve this you have to execute the following statements on the database:

ALTER TABLE visit DROP CONSTRAINT IF EXISTS fk_visit_caze_id;
ALTER TABLE visit ADD CONSTRAINT fk_visit_caze_id FOREIGN KEY (caze_id) REFERENCES cases (id);
CREATE INDEX IF NOT EXISTS idx_visit_caze_id ON visit USING HASH (caze_id);
CREATE INDEX IF NOT EXISTS idx_eventparticipant_resultingcase_id ON eventparticipant USING HASH (resultingcase_id);

This update adds an even title field and removes the event description column from the event directory. You can use the following SQL script to migrate the first 75 characters of every event description to the title of the same event (as long as the title field hasn't already been filled in) in order to not lose this information in the directory. The description field is still accessible as always in the event details view and in the detailed export:

UPDATE events SET changedate = now() WHERE eventtitle IS NULL OR eventtitle = '' AND archived = false AND deleted = false;
UPDATE events SET eventtitle = (SELECT CASE WHEN char_length(eventdesc) <= 75 THEN eventdesc ELSE (LEFT(eventdesc, 75) || ' ...') END) WHERE (eventtitle IS NULL OR eventtitle = '') AND deleted = false;

New Features

• [Web] Added a popup window on user login that asks the user to accept the GDPR terms (#2550)
• [Web] Added an event actions directory (#2907)
• [Web] Added the possibility to view percentage values for campaign diagrams (#2528 & [#2981])
• [Web] Added form and diagram customization options to campaigns (#2855)
• [Web] Added an import for campaign form data (#1999)

Improvements

• Added a new "Returning Traveler" field to contacts (#2603)
• [Web] Significantly improved loading times when opening a task with a lot of potential assignees (#2921)
• [Web] Significantly improved the performance of bulk-archiving (#2894)
• [Web] Added basic validation to phone number and email fields (#2910)
• [Web] Added "Set clear to unknown" button to symptom forms (#2584)
• Added "Unknown" as new present condition (#2769)
• [Web] Enhanced the default browser printing behaviour (#3020)
• [Web] Added a button to events that forwards the user to the case directory filtered by cases belonging to the event (#3021)
• Added a new "Event Title" field to events (#2904)
• [Web] Added a new "Action Title" field to actions (#2905)
• [Web] Added a new "Area" field to campaign data forms (#2982)
• Added facility fields to locations and refactored occupation facilities (#2456)
• Added a new "Quarantine before isolation" field for Switzerland (#2977)
• Added additional contact fields required for Switzerland (#2960)
• Added additional case fields required for Switzerland (#2959)
• Added a customized export option for Switzerland (#2975)

Changes

• [Web] Facility category and type are no longer editable for existing facilities (#3011)
• Made home description optional when selecting "Home" as the type of place of a case (#2989)
• Split the "General signs of disease" symptom into multiple symptoms (#2916)
• Adjusted the list of occupations for Switzerland (#2978)

Bugfixes

• Fixed automatic contact investigation task generation still triggering with deactivated contact task creation (#3115)
• [Web] Fixed text filters in directories taking into account phone numbers when letters were typed in (#3047)
• [Web] Fixed unsaved changes warning not working for sub forms (e.g. event participant) (#3042)
• [App] Fixed person pick/create dialog appearing when converting contacts to cases (#3066)
• [Web] Fixed bulk edit mode not properly toggling when switching between active/archived/all events (#3073)
• [Web] Fixed wrong travel end date validation (#2849)
• [Web] Fixed error when trying to sort contats by address and events by source type or participant count (#3026)
• [Web] Fixed de-archiving option not appearing when viewing archived cases (#3058)
• [Web] Fixed potential infinite loading issue in case/contact follow-up directories (#2969)
• [Web] Fixed campaign form data crash when data is not compatible (#3032)
• [Web] Fixed pathogen test result not being adopted when entered directly in the sample creation form (#3028)
• [Web] Fixed an error when accessing the case directory as a Point of Entry user (#3053)
• [Web] Fixed personal information being styled as pseudonymized even though it wasn't under specific circumstances (#3013)
• [App] Fixed delete option being displayed when creating previous hospitalizations, burials, gatherings or travels (#2871)
• [Web] Fixed searching for a source case when creating a contact producing wrong results when the search field was empty (#2329)
• [Web] Fixed responsible officer filter in case directory not always being properly filled (#3128)
• Fixed wrong interaction between investigation status and investigation task for cases (#2923)
• [Web] Fixed x-axis labels disappearing on smaller screens in campaign diagrams (#3065)
• [Web] Fixed popup prompt to activate the user mistakenly shown during user creation (#3071)
• Fixed ReST API URL basic authentication always resulting in authorized or forbidden (#3072)
• [Web] Fixed an error when trying to link a case to an event with no event in the database (#2684)

Integration

• [SORMAS2SurvNet] Added properties required to connect to the converter (#2671)
• [SORMAS2SurvNet] Added and implemented service layer to connect to the converter (#2672)
• [SORMAS2SurvNet] Added option to send cases to the converter (#2673)
• [Symptom Journal] Extended the ExternalVisit interface to provide additional information to Climedo (#2909)
• [Symptom Journal] Added functionality to inform Climedo about changes in person data (#2925)
• [Symptom Journal] External symptom journal state can now be displayed in SORMAS (#2083)

Security

• [Web] Fixed potential XSS security vulnerabilities (#2859)
• [Web] Added security headers to Vaadin response headers (#2991)

Testing

• Added cluster and screening event options to automated tests (#3116)
• Added apply filter changes to automated tests (#2912)

Documentation

• Added a guide on how to create campaign diagram definitions: https://github.com/hzi-braunschweig/SORMAS-Project/wiki/Campaign-Diagram-Definition (#3092)
• Extended the server customization guide with a list and description of database feature configurations (#3120)