Fixed Issues in 20R1.3 Release

Release Date: June 13, 2020

---

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

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

Jobs

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