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.