Skip to main content

Database

Create Multi Objects

Validates the input objects and, if validated, creates the list of objects in the database. It runs when all the input link points are active. If successful, triggers the newly created list of objects (if return top model object enabled, triggers the updated top-level object in a list); otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputlistList of input objects that will be created in the database
NameTypeDescription
createdlistList of newly created objects
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Created objects modelrequiredThe model of the objects that will be created in the database
Return top level model objectoptionalFlag to specify whether to return the updated top-level parent object or the newly created sub-model child object. Please note that this parameter is visible only if a child sub-model is selected for "Created object model".
Parent object idoptionalThe id of the parent object under which the sub-object(s) will be created. Required when the created objects are sub-model objects.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Create Single Object

Validates the input object and, if validated, creates the object in the database. If caching is enabled, it also caches the newly created object (if return top model object enabled, caches the updated top-level object) using its id as the cache key. It runs when all the input link points are active. If successful, triggers the newly created object (if return top model object enabled, triggers the updated top-level object); otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputobjectInput object that will be created in the database
NameTypeDescription
createdobjectNewly created object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Created object modelrequiredThe model of the object that will be created in the database
Return top level model objectoptionalFlag to specify whether to return the updated top-level parent object or the newly created sub-model child object. Please note that this parameter is visible only if a child sub-model is selected for "Created object model".
Parent object idoptionalThe id of the parent object under which the sub-object(s) will be created. Required when the created object is a sub-model object.
Cache created objectoptionalSpecify whether to cache the created object using its id as the cache key or not. If the object is cached and the timeout has expired, the cached object will automatically be removed from the cache.
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Database transactionoptionalTransaction context that this database operation will execute in
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Delete Multi Objects by Query

Deletes the objects matching the selection query in the database. It runs when all the input link points are active. If successful, triggers the deleteInfo otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputobjectInput object of the node, mainly used to specify the select query
NameTypeDescription
deleteInfoobjectDelete operation info object, which holds total query match and total deleted objects count information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Deleted object modelrequiredThe model of the object that will be deleted from the database
Select queryrequiredThe select query expression to find the objects that will be deleted
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Delete Single Object by Id

Deletes the object in the database with the provided object id. If remove from cache selected, it removes the deleted object (if return top model object enabled, removes the updated top-level object) from the cache using its id as the cache key. It runs when all the input link points are active. If successful, it triggers success and updated object (if return top model object enabled); otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputobjectInput object of the node, mainly used to specify object id
NameTypeDescription
successtriggerSuccessful delete operation trigger
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Deleted object modelrequiredThe model of the object that will be deleted from the database
Return top level model objectoptionalFlag to specify whether to return the updated top-level parent object or the newly created sub-model child object. Please note that this parameter is visible only if a child sub-model is selected for "Deleted object model".
Object idrequiredThe id of the object that will be deleted in the database.
Remove from cacheoptionalRemove deleted object from cache using deleted object id as the cache key
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Aggregate Results by Grouping

Retrieves a list of objects from the database matching the selection query, then groups these selected objects by the grouping expressions and performs the specified calculations on the grouped objects. It runs when all the input link points are active. If successful, triggers the result (computed expressions for each group) otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify input parameters of the node
NameTypeDescription
resultlistResults of the grouping operation. For each group, an object with the computed fields is returned.
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Grouped object modelrequiredThe model of the object that will be retrieved from the database for grouping
Select queryoptionalThe select query expression to retrieve the list of objects from the database.
Group byrequiredThe grouping method to apply on input objects for computations
ComputationsrequiredThe computation expressions that will be applied on each group
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Multi Objects by Query

Retrieves a list of objects from the database matching the selection query. It runs when all the input link points are active. If successful, triggers the result and countInfo (if selected) otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
resultlistList of objects retrieved from the database
countInfoobjectQuery result count info object, which holds total objects count matching the query condition, total pages, current page and page size information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Select queryoptionalThe select query expression to retrieve the list of objects from the database.
Sort expressionoptionalThe sort fields expression enables you to specify the sort direction as a parameter. If the sort expression is specified, it overrides the values specified in the sort fields below. This expression should either returns a text value (e.g., "fieldName:asc") or an array of text values (e.g., ["fieldName1:asc", "fieldName2:desc"]).
Sort fieldsoptionalThe list of model fields to use for sorting the query results
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Page numberoptionalPage number to paginate query results.
Page sizeoptionalMaximum number of items to fetch per page.
Return count infooptionalFlag to show/hide count info output link point.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Retrieves a list of objects from the database running first the text search and then applying the filter query to narrow down the results. The retrieved objects are sorted automatically in terms of the scores of the text search results. It runs when all the input link points are active. If successful, triggers the result and countInfo (if selected) otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
resultlistList of objects retrieved from the database
countInfoobjectQuery result count info object, which holds total objects count matching the query condition, total pages, current page and page size information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Search textrequiredA string of terms that are used to query the data model objects. This node performs a logical OR search of the terms unless specified as a phrase.
Additional select queryoptionalFollowing the search of model objects in database, the select query expression is used to further filter the list of objects retrieved from the database.
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Page numberoptionalPage number to paginate query results.
Page sizeoptionalMaximum number of items to fetch per page.
Return count infooptionalFlag to show/hide count info output link point.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Multi Objects & Count by Query

Retrieves a list of objects from the database matching the selection query and their count info (e.g., pagination data). It runs when all the input link points are active. If successful, triggers the result and countInfo otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
resultlistList of objects retrieved from the database
countInfoobjectQuery result count info object, which holds total objects count matching the query condition, total pages, current page and page size information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Select queryoptionalThe select query expression to retrieve the list of objects from the database.
Select query text expressionoptionalThe select query text expression enables you to specify the select query as a parameter. If the select query text expression is specified, it overrides the values specified in the select query below. This expression should return a text value that is used as the query expression.
Sort expressionoptionalThe sort fields expression enables you to specify the sort direction as a parameter. If the sort expression is specified, it overrides the values specified in the sort fields below. This expression should either returns a text value (e.g., "fieldName:asc") or an array of text values (e.g., ["fieldName1:asc", "fieldName2:desc"]).
Sort fieldsoptionalThe list of model fields to use for sorting the query results
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Page numberoptionalPage number to paginate query results.
Page sizeoptionalMaximum number of items to fetch per page.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Multi Objects Randomly

Retrieves the specified number of objects from the database randomly. It runs when the input link point is active. If successful, triggers the output list.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify size parameter
NameTypeDescription
outputlistList of objects randomly retrieved from the database
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the objects that will be randomly retrieved from the database
Select queryoptionalThe select query expression to retrieve the list of objects from the database.
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
SizeoptionalNumber of items to randomly select. If not specified randomly selected 20 items are returned.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Single Object by Id

Retrieves a single object from the database matching the object id. If caching is enabled first checks the cache using the id of the object as the cache key and if an object is found in the cache, returns the cached object. If no cached object is found, then returns the object from the database and caches the retrieved object. It runs when all the input link points are active. If successful, triggers found otherwise triggers notFound.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
foundobjectObject retrieved from the database
notFoundobjectObject not found trigger, returns the input object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Object idrequiredThe object id expression to retrieve the object from the database.
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Cache retrieved objectoptionalSpecify whether to cache the retrieved object using its id as the cache key or not. If the object is cached and the timeout has expired, the cached object will automatically be removed from the cache.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Get Single Object by Query

Retrieves a single object from the database matching the selection query. If caching is enabled, it also caches the retrieved object using the object id as the cache key. It runs when all the input link points are active. If successful, triggers the found otherwise triggers notFound.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
foundobjectObject retrieved from the database
notFoundobjectObject not found trigger, returns the input object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Select queryrequiredThe select query expression to retrieve the object from the database. If the selection query results in multiple matches, then the first entry is returned.
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Cache retrieved objectoptionalSpecify whether to cache the retrieved object using its id as the cache key or not. If the object is cached and the timeout has expired, the cached object will automatically be removed from the cache.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Update Multi Objects by Query

Validates the input and updates the objects matching the selection query in the database with values provided in the input. It runs when all the input link points are active. If successful, triggers the updateInfo otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputobjectThe updates that will be performed on the object in the database
NameTypeDescription
updateInfoobjectUpdate operation info object, which holds total query match and total updated objects count information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Updated object modelrequiredThe model of the object that will be updated in the database
Select queryrequiredThe select query expression to find the objects that will be updated
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Update Object Fields by Id

Validates the provided field values and object id and if validated, updates the object with the provided object id in the database with new field values. Either sets the new values, unsets existing values, for numerical values increments, decrements, multiplies existing values, or takes the min or max of values and for basic values list arrays adds or removes elements to the list. If caching is enabled, also caches the updated object (if return top model object enabled, caches the updated top-level object) using its id as the cache key. It runs when all the input link points are active. If successful, it triggers the updated object (f return top model object enabled, triggers the updated top-level object); otherwise triggers errors.

Multi input✔️
Multi output

No fixed input link points, all inputs are dynamic.

NameTypeDescription
updatedobjectUpdated object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Updated object modelrequiredThe model of the object that will be updated in the database
Return top level model objectoptionalFlag to specify whether to return the updated top-level parent object or the newly created sub-model child object. Please note that this parameter is visible only if a child sub-model is selected for "Updated object model".
Object idrequiredThe id of the object that will be updated in the database.
Field value updatesrequiredThe list of fields and their new values to be updated in the database.
Cache updated objectoptionalSpecify whether to cache the updated object using its id as the cache key or not. If the object is cached and the timeout has expired, the cached object will automatically be removed from the cache.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Update Object Fields by Query

Validates the provided field values and updates the objects matching the selection query in the database with new field values. It runs when all the input link points are active. If successful, triggers the updateInfo otherwise triggers errors.

Multi input✔️
Multi output

No fixed input link points, all inputs are dynamic.

NameTypeDescription
updateInfoobjectUpdate operation info object, which holds total query match and total updated objects count information
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Updated object modelrequiredThe model of the object that will be updated in the database
Select queryrequiredThe select query expression to find the objects that will be updated
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Field value updatesrequiredThe list of fields and their new values to be updated in the database.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Update Single Object by Id

Validates the input and object id and, if validated, updates the object with the provided id in the database with values provided in the input. If caching is enabled, it also caches the updated object (if return top model object enabled, caches the updated top-level object) using its id as the cache key. It runs when all the input link points are active. If successful, triggers the updated object (if return top model object enabled, triggers the updated top-level object); otherwise triggers errors.

Multi input✔️
Multi output
NameTypeDescription
inputobjectThe updates that will be performed on the object in the database
NameTypeDescription
updatedobjectUpdated object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Updated object modelrequiredThe model of the object that will be updated in the database
Return top level model objectoptionalFlag to specify whether to return the updated top-level parent object or the newly created sub-model child object. Please note that this parameter is visible only if a child sub-model is selected for "Updated object model".
Object idrequiredThe id of the object that will be updated in the database.
Cache updated objectoptionalSpecify whether to cache the updated object using its id as the cache key or not. If the object is cached and the timeout has expired, the cached object will automatically be removed from the cache.
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Create Object Iterator

Retrieves objects from the database matching the selection query and creates an iterator (cursor) to iterate through the query results. It runs when all the input link points are active. If successful, triggers the iterator object.

Multi input✔️
Multi output
NameTypeDescription
inputObjectobjectInput object of the node, mainly used to specify selection filter
NameTypeDescription
iteratorobjectIterator (cursor) object
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Retrieved object modelrequiredThe model of the object that will be retrieved from the database
Select queryoptionalThe select query expression to retrieve the list of objects from the database.
Sort expressionoptionalThe sort fields expression enables you to specify the sort direction as a parameter. If the sort expression is specified, it overrides the values specified in the sort fields below. This expression should either returns a text value (e.g., "fieldName:asc") or an array of text values (e.g., ["fieldName1:asc", "fieldName2:desc"]).
Sort fieldsoptionalThe list of model fields to use for sorting the query results
Lookup fieldsoptionalThe referenced object fields to perform a left outer join for processing
Database transactionoptionalTransaction context that this database operation will execute in
Apply rulesoptionalEnable/disabled execution of object level security rules that define the conditions to allow or restrict certain operations (create, read, upddate, delete) on your app database, storage and cache.
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Iterate to Next Object

Gets the next available object from the iterator. It runs when the trigger and iterator are active. If successful, triggers found otherwise triggers notFound.

Multi input
Multi output
NameTypeDescription
triggertriggerTrigger of the node
iteratorobjectIterator object to iterate over query results
NameTypeDescription
foundobjectNext object retrieved from the iterator
notFoundtriggerObject not found trigger
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Abort Transaction

Aborts the active transaction. It runs when the trigger link point is active.

Multi input
Multi output
NameTypeDescription
triggertriggerTrigger of the node
NameTypeDescription
successtriggerOutput trigger of successful execution of the node
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Database transactionrequiredTransaction object that will be aborted
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.

Commit Transaction

Commits the active transaction. It runs when the trigger link point is active.

​Title​Title
Multi input​​❌
Multi output​​❌
NameTypeDescription
triggertriggerTrigger of the node
NameTypeDescription
successtriggerOutput trigger of successful execution of the node
errorslistErrors occurred during node execution

Parameters

NameTypeDescription
Database transactionrequiredTransaction object that will be committed
Error managementrequiredError handler type of processing errors raised by this node, either automatically or manually.