Release Notes

Graphql

Generic querying of Data Model Extensions (DMEs)

Added support for generically querying data model extensions (DMEs) in the schema. Currently, DMEs are only available for selected customers. The schema extensions can be used (although not recommended) to query the core data model too. See GraphQL Extensions.

Graphql

Filtering on joined tables

Support for filtering values from joined tables. See Filtering on joined tables.

Graphql

suggest undeprecated and merged with values

Undeprecated the suggest argument and merged its functionality with the values argument for suggesting values when inserting new rows to avoid using null values. See Suggested values.

Graphql

Deprecated invalid join fields

Deprecated join fields that are invalid (either return incorrect data or produce an error). See Deprecated joins.

Graphql

Fix: availableCompanies missing organizationNo fix

Fix: availableCompanies returns companies but without organizationNo when user does not have access to the company table.

Graphql

Improved error for object passed to object-array variable

Improved error message when an object is passed for a variable that expects an array of objects.

Graphql

Improved error when async request deletion fails

Improved error message when an async request cannot be deleted.

Graphql

Field-level assignment names in mutation errors

Better error information by providing the name of fields whose assignment failed in create or update mutations. See Understanding error information.

Graphql

New domain fields: identifier, domainTypeNo, domainTypeNoAsEnum

New fields identifier, domainTypeNo, and domainTypeNoAsEnum for domains in model information. See Model information.

Graphql

Fix: Query execution with sort sequence column in orderBy fix

Fix: execution of queries when the sort sequence column is included in list of sort columns (orderBy argument).

Graphql

Fix: Input object variable field order preserved fix

Fix: passing input objects using variables for create or update mutations preserves the order of fields.

Graphql

orderBy added to availableCompanies and availableCustomers

Introduced the orderBy argument for sorting the results of availableCompanies and availableCustomers queries to be consistent with arguments for connection types. The existing sortOrder argument is deprecated and will be removed in the future.

Graphql

Fix: Update filtering with empty value/values fix

Fix: the filtering of results on an update operation with an empty value/values argument.

Graphql

Create head and line records in one insert

Support for creating head and line records (for order-order lines and batch-voucher) in a single insert operation. See Inserting head and line rows.

Graphql

Temporary record creation support

Support for creating temporary records. See Temporary rows.

Graphql

Multiple mutation operations in one async request

Improved support for async queries: multiple delete and insert/update operations can be executed in a single async request. See Async queries.

Graphql

Timestamp comparisons with current datetime

Support for comparing timestamp fields (createdTimestamp and changedTimestamp) with current date/time and better error messages for invalid ReferenceDateTime values. See Comparing with current date/time.

Graphql

Deprecation warnings returned in extensions

Return a warning (as part of extensions) for every deprecated feature used in a request. See Deprecated features.

Graphql

Fix: Async multi insert/update returns correct results fix

Fix: async requests with multiple insert/update operations return correct results.

Graphql

GraphQL reads executed directly in middleware

GraphQL requests are dispatched to middleware service for processing, which can execute directly most reads (and other operations in the future) without sending them further to the VBus backend. This is the same execution improvement that was introduced for the front-end earlier this year.

Graphql

GraphiQL upgraded to 4.x

Upgraded GraphiQL web IDE to version 4.x.

Graphql

Improved messages for specific errors

Better error messages for some specific errors

Graphql

Fix: Joined results with unset foreign key fix

Fix: joined results when foreign key is not set (default value)

Graphql

Stricter access-right filtering in mutations and metadata

Change of access rights handling: tables that are not readable will no longer appear in mutations for create/update/delete. Processings and reports will also be unavailable for these tables. Columns that are not readable will not be available in input types for create and update operations.

Graphql

Enumeration type domain support

Support for enumeration type domains for columns, arguments, or result values. See enum fields.

Graphql

@dependsOn directive support

Support for specifying that a field’s execution depends on another one. See the @dependsOn directive.

Graphql

Delete asynchronous request jobs

Support for deleting an asynchronous request job. See deleting an asynchronous request.

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.

Graphql

Multiple edits in a single update operation

Support for collecting multiple edits in a single update operation. See Update operations.

Graphql

Synchronous timeout increased to 59 seconds

Increased internal execution timeout to 59 seconds to allow longer synchronous operations. This value may be subject to change. Async queries are recommended for long running operations.

Graphql

Fix: Bitflag values in query variables fix

Fix: Support for bitflag values passed in query variables. See Bitflags.

Graphql

Export values to array variables

Support for exporting values to an array variable. See the @export directive.

Graphql

Fix: _or filters with changedDateTime/createdDateTime fix

Fix: correct handling of filters with changedDateTime/createdDateTime and other _or expressions

Graphql

Error responses now include status_name

Include name of status codes (with status_name) in error data not just status codes. See Error handling.

Graphql

Fix: byte values in processing/report arguments fix

Fix: support for byte values in processing/report arguments

Graphql

Fix: Partial finish order fix

Fix: partially finish order

Graphql

Fix: Correct hasNextPage when all data is fetched fix

Fix: hasNextPage report correct value when all data has been fetched

Graphql

Fix: More fields can be set to null for suggested values fix

Fix: allow more field to be set to null in order to request to suggest value

Graphql

Batched request support

Support for batching multiple requests together. See Batched requests.

Graphql

Record skipping support

Support for skipping records. See Pagination.

Graphql

Improved bit flags column handling

Better support for working with bit flags columns. See Bitflags.

Graphql

Model information query support

Support for fetching model information. See Model information.

Graphql

_in and _not_in filter operators

Support for _in and _not_in operators in filters. See Filtering.

Graphql

New null-based suggested value ordering

Added a new way to suggest values in the correct field order using null values. See Suggested values.

Graphql

Deprecated suggest argument

Deprecated the suggest argument for suggesting values.

Graphql

Removed deprecated suggestValues argument

Removed the deprecated suggestValues argument for suggesting values.

Graphql

Distinct values query support

Added support for fetching distinct values. See Distinct values.

Graphql

availableCustomers for service integrations

The availableCustomers field works for service-to-service integrations.

Graphql

availableCompany returns companies across all customers

The availableCompany returns all the companies from all customers if no customer ID was provided, not just the companies of the first found customer (as previously available).

Graphql

availableCompanies includes vismaNetCustomerId

Company information from the availableCompanies field includes customer ID with the vismaNetCustomerId field.

Graphql

Breaking change: useCustomer for system tables

breaking change: Access to system tables available under the new useCustomer field both for queries and mutations. See Accessing system tables

Graphql

suggest restored; suggestValues deprecation announced

Better support for suggesting values with the suggest argument. The previous suggestValues argument is deprecated and will be removed after 1 March 2023. See Suggested values.

Graphql

Fix: @export execution order fix

Fix for @export directive. Nodes using exported variables execute only after variables have been resolved.

Graphql

Join query performance improvements

Improved performance for queries containing joins. See Unoptimized queries.

Graphql

Async query response includes creation and completion timestamps

Added the creation and completion time in the result value for asynchronous queries. See Async queries.

Graphql

Fix: Mutation timeout when record is not found fix

Fix for mutations timeout when a record is not found.

Graphql

Client-credentials support for availableCompanies

Support for fetching available companies when using client credentials grant type for the access token (for service-to-service integrations). See Fetching user’s available companies.

Graphql

Added @export custom directive

Added the @export custom directive. See Directives.

Graphql

Suggested values for insert operations

Support for suggesting values when inserting new rows. See Suggested values.

Graphql

Full alias support in queries

Full support for aliases in queries. See Aliases.

Graphql

Asynchronous query support

Support for asynchronous queries. See Async queries.

Graphql

Brotli compression for all responses

Added Brotli compression for all responses.

Graphql

Service-to-service integration support

Support for service-to-service integrations. See Service integrations.