Fixed Issues in 19R3.5 ReleaseRelease 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)
|To get an event's DateTime from the header, CQL required "@HDR.Event.Datetime" instead of "@HDR.Event.DateTime".
|With this release, we added support for the TIMESTAMPDIFF() function in CQL.
|Core listings may have the "ERROR: folded header size should be the same as row size" error.
|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.
|CQL doesn't allow the use of item-level functions, such as ILB(), within subqueries.
|Workbench returns an error when a CQL statement includes a subquery join.
|CQL doesn't filter on @Form.SeqNbr.
|Wildcard (*) selection from a subquery fails.
|CQL results may be inconsistent when a vault has more than one Study loaded into Workbench.
|CQL results may be inconsistent when a Study has two sources that each have a Form with the same name.
|Workbench returns a mapping error without an error code when the manifest file lists an Item name that contains whitespace characters.
|CQL doesn't support UTF-8 characters in values.
|Users receive an error when using DESCRIBE ITEM on an Item from a 3rd party data package.
|Re-importing a Study may fail unexpectedly due to a timeout.
|During data import, Workbench imports items with the date format "MM-dd-yy" (MM-dd-19yy) as "MM-dd-20yy".
|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.
|Workbench may return duplicate rows for non-repeating Item Groups when the Form also contains at least one repeating Item Group.
|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.