# 2021 v3

## Content



## DataEngine

**Bug Fixes**

*   Fixed the issue where the FlexPivot did not update when setting the format to Quarter/Week/Fiscal.
*   Fixed the issue where the FlexPivot Input string was not in a correct format (in Chart tab).
*   Fixed the issue where the Row count is not shown upon startup for the DataEngineCollectionSample.
*   Fixed the issue where the errors occur when editing value in DataEngineCollectionSample.
*   Fixed the issue where the the ShowAs.PctGrand in FlexPivot incorrectly references first column.
*   Fixed the issue where the Workbench app could not install in Windows.
*   Fixed the issue where the inconsistent behavior when editing search text in DataEngineCollectionSample.
*   Fixed the issue where there are errors when sorting multiple columns in DataEngineCollectionSample.
*   Fixed issue where when setting KeepFiles to None did not discard any query results.
*   Fixed the issue where the FlexPivot doesn't update when the format is set to Quarter/Week/Fiscal.
*   Fixed the issue where row totals are incorrect for Avg/Std/Var when there are no column fields.

**Improvements**

*   Added time series and fiscal year examples to PetLicenses sample.
*   Added time series functions Ytd, Mtd, Qtd, Wtd (year/month/quarter/week-to-date).
*   Added Workspace.FiscalYearFirstMonth property (works with Ytd/Qtd functions).
*   Added the new C1.DataEngine.Collection library.

## DataCollection

**Bug fixes**

*   Fixed the issue where filtering C1BindingListDataCollection was throwing an exception in numeric operations.

**Improvements**

*   Avoids creating a dynamic item type in C1CollectionViewDataCollection if the type of the SourceCollection of the passed collection-view is generic and the properties are the same as the returned by the System.ComponentModel.IItemProperties interface.
*   [DataCollection.EntityFrameworkCore\] Added new constructor in both C1EntityFrameworkCoreCursorDataCollection and C1EntityFrameworkCoreVirtualDataCollection accepting an IQueryable\<T>. This allows displaying related tables that are not in the main DBContext but got from the Query method of CollectionEntry.

## DataConnector

**Bug Fixes**

*   [C1.AdoNet.D365S\] Fixed error message in D385S when the connection string is empty.
*   [C1.AdoNet.Json\] Fixed issue where the data at the last index is always deleted in JSON provider.
*   [C1.AdoNet.Json\] Fixed the issue of query with datetime in cache mode in JSON provider.
*   [C1.AdoNet.Kintone\] Fixed the issue of executing a query with 'Is Not Null'.
*   [C1.AdoNet.Kintone\] Fixed the issue of executing a query that filters fields with 'Boolean' / radio button setting.
*   [C1.AdoNet.OData\] Fixed the issue where the internal class C1CacheCommand and C1CacheConnection is explicitly hidden from the toolbox.
*   [C1.AdoNet.QuickBooksOnline\] Fixed the error message that is thrown instead of appropriate error message like other data providers.

**Improvements**

*   [C1.AdoNet.Json\] Added support for Scaffolding in JSON provider.
*   [C1.AdoNet.Json\] Added support for VS integration in JSON provider.
*   [C1.AdoNet.Json\] Added support for insert statement for JSON provider.
*   [C1.AdoNet.Json\] Added support for update statement for JSON provider.
*   [C1.AdoNet.Json\] Added support for delete statement for JSON provider.
*   [C1.AdoNet.Json\] Added support for batch/mix insert/update/delete in JSON provider.
*   [C1.AdoNet.Json\] Updated EFcore to support insert/update/delete.
*   Initial version of C1.AdoNet.Salesforce.Designer.
*   [C1.EntityFrameworkCore.Json\] Support Scaffolding in JSON provider.