Fixed Issues in 19R3.5 Release

Release Date: April 10, 2020

This week's release includes fixes for the following issues:

A * next to the issue number denotes an internally found defect filed during the development of Limited Release features.

Clinical Query Language (CQL)

Issue Description Issue No.
To get an event's DateTime from the header, CQL required "@HDR.Event.Datetime" instead of "@HDR.Event.DateTime". VDC-29511*
With this release, we added support for the TIMESTAMPDIFF() function in CQL. VDC-37643*
Core listings may have the "ERROR: folded header size should be the same as row size" error. VDC-39906*, VDC-39751*
When a CQL statement selects from two Forms within the same Event, including @Form.Status in a WHERE clause splits a Subject across two rows. VDC-40882*
CQL doesn't allow the use of item-level functions, such as ILB(), within subqueries. VDC-41007*
Workbench returns an error when a CQL statement includes a subquery join. VDC-41200*
CQL doesn't filter on @Form.SeqNbr. VDC-41787*
Wildcard (*) selection from a subquery fails. VDC-41821*
CQL results may be inconsistent when a vault has more than one Study loaded into Workbench. VDC-41939*
CQL results may be inconsistent when a Study has two sources that each have a Form with the same name. VDC-42082*
Workbench returns a mapping error without an error code when the manifest file lists an Item name that contains whitespace characters. VDC-42782*
CQL doesn't support UTF-8 characters in values. VDC-43056*
Users receive an error when using DESCRIBE ITEM on an Item from a 3rd party data package. VDC-43655

Data Workbench

Issue Description Issue No.
Re-importing a Study may fail unexpectedly due to a timeout. VDC-41586*
During data import, Workbench imports items with the date format "MM-dd-yy" (MM-dd-19yy) as "MM-dd-20yy". VDC-42783*
Workbench doesn't return an error when a user imports a data package that has a "sequence" column mapped in the manifest file but doesn't have that column in the CSV file. VDC-42790
Workbench may return duplicate rows for non-repeating Item Groups when the Form also contains at least one repeating Item Group. VDC-44323*
After a successful load of 3rd party data, if a user attempts to load a second package, with a different source but a CSV file with the same name as one in the previous package, Workbench doesn't create a new core listing for that second form. VDC-44457