Release Notes 2024

Availability of new createdTimestamp and changedTimestamp datetime fields on all tables. See Date and time fields.

Improved error messages for two scenarios where available companies cannot be fetched.

Fix: date fields suffixed with AsDate return null if the date is invalid, instead of throwing an error. The situation can arrive when an invalid date was set in the system (a feature used in some limited scenarios). The actual date can still be fetched using the column field of type Int.

Support for specifying the language in useModel nodes with a numerical value (eg. 47 for Norwegian). See Language selection.

Improved messages for some category of errors (context failures).

Support for inserting records in between existing ones. See Insert between existing records.

Extended model information with relations and domain members and access restrictions, availability, and additional properties for each entity type. See Model information.

Fields assigned from unset variables are ignored in insert/update mutations. See Assigning fields from unset variables.

Support for comparing date and time fields with the current date and time. See Comparing with current date/time.

New argument orderBy for defining the sorting order of the results. See Sorting.

Fixed bug that affected blob fields: base-64 encoded values were stored instead of the actual binary data.

Support for fetch distinct values using a new query argument called distinct. See Distinct values.

Fix: incorrect results when filtering with _is_null / _is_not_null on blob columns.

Support for _in / _not_in operators in having expressions.

Support for _between / _not_between operators in filters and having expressions. See Filtering: _between / _not_between operators.

Support for domain information in the model. See Model information.

Eased some limitations on async requests. See Async queries.

Defined a limit of 32 requests in a batch. See Batched requests.

Improved description of table columns in the schema. See Understanding column descriptions.

Async queries return correct results when fetching data from multiple tables in a single query. Also the totalCount fields works as expected. See Async queries.

Added createdDateTimeUtc and changedDateTimeUtc as well as createdDateTimeTZ and changedDateTimeTZ for filters. See Datetime special fields.

Performance improvement for pagination when hasNextPage is requested. For tables of tens of millions of records, the execution time is reduced with 20-25 seconds.

Empty arrays for _in and _not_in comparison operators in filter result in no data being returned. See Filtering.

Fixed Illegal query bug for some queries that fetch aggregates using the group by feature.

Fixed Unknown company error when a join operation (joinup_ or joinddown_ field) is used in the projection a mutation request.

Added support for grouping by data. See Grouping.

Define changedDateTime with second and millisecond precision for table that include the changeTimeInMs column. See Date and time fields.

Removed the restriction of executing a single async query at a time. See Async queries.

The path of a failed assignment in an update request (index of record) included an error object. See Error handling.

The path of a failed assignment in a create or update request included the error object when the operation is executed asynchronously.