Creating export definitions
After clicking the “New Export” button, a new page “Data export” opens, where users can define and configure the export based on various criteria. The following filters and settings are currently available:
- Filter by date: filter the data export by modification date (all data) or episode date (for longitudinal data)
- Filter by form status: filter the data export by form status (All, Open, Reported, Validated)
- Export settings: customize the meta-information included in the data export
- Search criteria: define queries to only include patients matching specified criteria in the data export
- Items to export: select the data elements to be included in the data export
Filter by date
The “changed between” filter can be used to limit the data export to data that has been entered or modified within a certain time period. To filter by modification date, enter the dates next to “Changed between” or select the respective dates using the built-in calendar. The “episode date” filter can be used to limit the data export to longitudinal data that is associated with a specific date or period. To filter by modification date, enter the dates next to “Episode date between” or select the respective dates using the built-in calendar.
Filter by form status
In addition, the data export can be filtered based on the form status. The form status allows users to indicate the current state of the form when entering data. When defining a data export, the following selections are available: "all", "open", "reported", and "validated". The "all" option specifies that all forms should be exported, regardless of their status. The "Open" option is selected if the form has not yet been closed or edited. "Reported" indicates that the form has been reported and is awaiting review or validation. "Validated" means that the form has been successfully validated and is considered correct or completed.
Export settings
Various options are available to adapt the data export to individual requirements:
- Latest episode of each patient only: if checked, only the latest episode of each patient is included in the data export.
- URN abbreviation in CSV: if checked, only the ID of an item (form, record, data element) is included in the data export (e.g. “84”) instead of the full URN (e.g. urn:osse-2:dataelement:84:*) to make the data more compact.
- Include location ID in CSV: if checked, only the ID of a location is included in the data export instead of the location name.
- Include location name in CSV: if checked, only the full name of a location is included in the data export.
- Include form status in CSV: if checked, information about the form status of each form is included in the data export.
Set search criteria
To query registry data according to specific medical criteria, the "Edit search criteria" function is available. This allows users to customize search criteria in a separate query builder and make a targeted selection of relevant patients. Further information can be found under Setting search criteria
Select items to export
In addition, it is possible to restrict the export to relevant data elements und "Items to export". Here, all data elements from the MDR used in the registry are listed and can be included in the data export by checking the respective checkbox. Furthermore, there is the option to select all available data elements by activating the first checkbox ("Check all/Uncheck all") in order to perform a full export.