20R3 CDB Pre-Release Fixed Issues

---

Release Number: 20R3.0 Pre WRB | Build Number: 59

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

CDB - CQL

Issue Description	Issue No.
CQL returns an error when the statement uses UnPivot on multiple Forms within a subquery.	VDC-56356*
CQL returns an unknown column error when the statement references the @HDR in an UnPivot() function.	VDC-56396*
CQL may not return a value for all rows for CodedDictRel().	VDC-60145
CQL returns the default value of "1" for ItemGroupSeqNbr() for non-repeating Item Groups on Forms that haven't been submitted.	VDC-62045*
CQL treats the value of @ItemGroup.SeqNbr as "null" whenever it is referenced in a function.	VDC-62369

CDB - Export

Issue Description	Issue No.
The Sys_ILB listing displays each column header twice (e.g. "ILB Reason ILB Reason").	VDC-57787*
WIth this release, raw Export Listings don't support COMPACT, as it results in data folding on ItemGroup.Name.	VDC-61768*
Sys_ILB no longer fully quaifies ItemGroup.Name, which shortens the column values and prevents errors during package generation.	VDC-62538*
With this release, the Latest Package column now includes the format (CSV or SAS).	VDC-62763*
In Export > Packages, selecting Process Date in the Sort By menu doesn't sort the list of packages by Process Date.	VDC-63017*
Generation of the Sys_Forms listing's CSV file fails when there are more than 61 Forms in the study.	VDC-63063*

CDB - Import

Issue Description	Issue No.
In certain circumstances, importing a third party data package can remove queries from EDC.	VDC-62152*

CDB - Listings

Issue Description	Issue No.
Certain Core Listings may display extra columns for decorations that list obiect record IDs.	VDC-56168*
When a user toggles Review Enable, the Properties dialog freezes.	VDC-60922*
When a user creates a Review Listing and marks that listing as Private, deleting that listing in the Review tab moves it to the Private tab and vice versa, which prevents deletion of the listing.	VDC-61703*
Workbench doesn't display all Forms in the Listing Header for Review Listings.	VDC-61907*
Workbench doesn't update the Review Status in the Review column until the user refreshes the page.	VDC-62370*
When the CQL Editor is read-only, and the statement is invalid, the read-only banner covers the error message.	VDC-62371*
Workbench doesn't add the Delta icon when a reviewed record is updated by an EDC import.	VDC-62395*
Imports completed after a user performs review on a form may modify the review date.	VDC-62757*
Users can't filter on the Reviewed with Delta review status.	VDC-63283*

CDB - Queries

Issue Description	Issue No.
Users aren't able to create queries on event dates from Review Listings.	VDC-63233*
In the Cell Details panel for a query, the Close and Reply buttons are outside the viewable area.	VDC-63290*
For third party data, the Cell Details panel doesn't display query details.	VDC-63291*

Data Entry

Issue Description	Issue No.
Users receive a server error after selecting the Lab Tests Not Performed checkbox.	VDC-58437*