Retrieve

Last modified: February 13, 2024

1 Introduction

A Retrieve activity can be used to get one or more objects, either by directly traversing an association of another object, or by retrieving objects from the database.

2 Properties

An example of retrieve properties is represented in the image below:

retrieve properties

There are two sets of properties for this activity, those in the dialog box on the left, and those in the properties pane on the right.

The retrieve properties pane consists of the following sections:

3 Action Section

The Action section of the properties pane shows the action associated with this activity.

You can open a dialog box to configure this action by clicking the ellipsis () next to the action.

You can also open the dialog box by double-clicking the activity in the microflow or right-clicking the activity and selecting Properties.

3.1 Source

The Source defines the way the objects are retrieved:

Option Description
By association Retrieve the object(s) associated to an object by following an association. Note that when objects and/or their associations are changed and not committed, the data is not yet available in the database. By retrieving By association, the data that is not committed can be retrieved. For more information, see the Retrieve by Association Properties section below.
From database Retrieve objects from the database. For more information, see the Retrieve from Database Properties section below.

3.2 Retrieve by Association Properties

3.2.1 Association

This property specifies which association will be followed. The association must be an association from an object that is already available to the retrieve activity. Associations can be followed in both directions.

3.3 Retrieve from Database Properties

3.3.1 Entity

This property specifies the entity from which to retrieve instances (objects).

3.3.2 Range

This property specifies the range that determines how many objects are retrieved:

Range Meaning
All Retrieve all objects at once.
First Retrieve only the first object. The result of the retrieve action will be a single object instead of a list. Note that when you know you have only one object or you only want to use the first object in a list, use First to get a result of the object type (as opposed to a list).
Custom Retrieve a given number of objects (Amount) starting at a given index (Offset). The amount and offset are expressions that should result in a number. Note that the first object has an offset of 0. An amount of 0 means that all objects are retrieved.

3.3.3 XPath Constraint

The XPath constraint defines the condition the objects need to fulfill to be retrieved. If there is no XPath constraint, all objects of the entity are retrieved.

3.3.4 Sorting

This property defines the order of the list. The list can be sorted in ascending and descending order on the values of an attribute. If there are objects that have the same attribute value, the list is sorted based on the second attribute (if any) and so on.

3.4 Type

This read-only property indicates whether you will retrieve a singe object or a list.

3.5 List Name or Object Name

This is the name of the list or object returned by the activity. It can be used by all the activities that follow this activity.

4 Common Section

For more information on properties in this section, see Common Properties.