Fixed Issues in 20R1.3 Release

Release Date: June 13, 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.
CQL returns an "Unknown column @Form.{attribute} in 'field list'" error when an IFNULL function references an @Form attribute. VDC-35420*
CQL returns an error when describing Forms from multiple Sources. VDC-39756*
Item functions don't handle null values appropriately when there is a repeating Item Group. VDC-41278*
Subquery joins for Subject may not be applied correctly. VDC-41605*
CQL doesn't apply the specified sort order when the Item referenced in the ORDER BY clause is within a repeating Item Group. VDC-41912*
CQL returns an "Unknown column @Form.{attribute} in 'order clause'" error when the statement selects from multiple Forms and is ordered by @Form.Name or @Form.SeqNbr. VDC-42156*, VDC-46336*
When CQL returns a null value for a @HDR, it returns all values as null. VDC-43215*
When Forms have a repeating Item Group, CQL groups data by Form and Item Group, even when no @Form or @ItemGroup attributes are included in projection. VDC-43342*, VDC-46833*, VDC-46830*, VDC-46309*
IS NULL doesn't filter out null values appropriately for @ItemGroup.SeqNbr. VDC-43350*
Users may receive a "not finding folding key" error. VDC-43772*
CQL may not return all possible results when selecting from multiple Forms. VDC-44330*
CQL may return a "No value present" error when selecting from a repeating Form. VDC-44577*
Sorting using the Sort & Filter menu doesn't work correctly on Items within repeating Item Groups. VDC-45879*, VDC-43344*
CQL returns errors when a statement selects from multiple Forms and at least one of those Forms contains a repeating Item Group. VDC-46107*
When a repeating Form contains multiple repeating Item Groups, @Form.SeqNbr shows data holes and CQL may return the data from each Item Group in the incorrect row. VDC-46306*
CQL returns an error when a form identifier is too long. VDC-46329*
In certain circumstances, CQL may return a "Duplicated Form context found for::{form}" error. VDC-46334*
CQL returns a mismapped input error when a form's Name contains a forward slash ("/") or a plus sign ("+"). VDC-46595*
CQL may return a "folded header size should be the same as row size" error when selecting only @Form.Name. VDC-47283*

Data Workbench

Issue Description Issue No.
Workbench doesn't list the Forms within a listing when the listing pulls data from multiple Sources. VDC-46657*
If a user navigates to a subsequent page of results, and then filters the listing, Workbench shows no results. VDC-46832*
When using Internet Explorerâ„¢, users may be unable to generate CSVs for their listings. VDC-47447
In certain cases, Workbench may not load listings from all Sources available for a Study. VDC-47566


Issue Description Issue No.
In the Workbench Export job completion email, the link to download the output file doesn't open to download the file. VDC-43071
For scheduled Workbench Export jobs, Vault doesn't use the current date when naming the job's output file. VDC-45818