Release Notes 2024

Graphql

Added createdTimestamp and changedTimestamp on all tables

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

Graphql

Improved errors when available companies cannot be fetched

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

Graphql

Fix: Invalid AsDate values now return null fix

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.

Graphql

Numeric language codes in useModel

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

Graphql

Improved context failure error messages

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

Graphql

Insert records between existing rows

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

Graphql

Expanded model metadata for entities and relations

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

Graphql

Ignore unset-variable assignments in insert and update

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

Graphql

Compare date/time fields with current datetime

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

Graphql

New orderBy sorting argument

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

Graphql

Fix: Blob fields now store binary data correctly fix

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

Graphql

New distinct query argument

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

Graphql

Fix: _is_null and _is_not_null on blob columns fix

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

Graphql

_in and _not_in support in having

Support for _in / _not_in operators in having expressions.

Graphql

_between and _not_between in filters and having

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

Graphql

Domain metadata available in model information

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

Graphql

Relaxed async request limitations

Eased some limitations on async requests. See Async queries.

Graphql

Batch requests limited to 32 operations

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

Graphql

Improved table column descriptions

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

Graphql

Fix: Async multi-table queries return correct totalCount fix

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.

Graphql

Added UTC and timezone datetime filter fields

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

Graphql

Faster pagination with hasNextPage

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.

Graphql

Empty _in and _not_in arrays now return no rows

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

Graphql

Fix: Illegal query in grouped aggregates fix

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

Graphql

Fix: Unknown company in mutation join projections fix

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

Graphql

Group-by query support

Added support for grouping by data. See Grouping.

Graphql

Millisecond precision for changedDateTime

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

Graphql

Removed single-async-query execution limit

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

Graphql

Update assignment failures include error in path

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

Graphql

Async create/update assignment failures include error in path

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