Retrieving Entities with the Fetch Entities Flow Step
  • Updated on 09 May 2013
  • 2 minutes to read
  • Print
  • Dark
    Light

Retrieving Entities with the Fetch Entities Flow Step

  • Print
  • Dark
    Light

The Fetch Entities step is a flow step that allows for fetching of any entity within the system, such as folders, native data types, stored database types, and custom data types. The Fetch Entities step is found in the Toolbox under Integration > Entity Framework . The step allows for filtering on any property for the entity. Note that deleted entities are not retrieved.

Example

This example will fetch folders and display them in a folder list on a form.
We begin in the Designer Folder by clicking Create Flow button from the Folder Actions Panel.
2018-02-05_142619-1024x540.png

Next, Name the Flow and click Create to proceed to the Flow Designer .

2018-02-05_142712-1024x540.png

In the Flow Designer, expand Integrations > All Integrations > Entity Framework and add Fetch Entities step to the workspace.

2018-02-05_142738-1024x540.png

Then, from the Forms [Interaction] > [Current Folder] in the Toolbox add a Form that was predesigned for this Flow.  The purpose of this Form is to display fetched Folders with Data Grid component. This Form is designed as following:

2016-12-04_131027.png

Connect steps in the Flow as following:

2018-02-05_143810.png

Then, configure the steps. First, select Fetch Entities step on the work space and navigate to theEntity Fetch Definition configurations. In the Type Name textbox search and select Folder data type.

2018-02-05_143849-1024x540.png

Next, select the Form step and choose Select Value Mapping Type for the FoldersList input (which is a name for the Data Grid component on the Form ). Then, using Path selector pick EntityResults output from the Fetch Entities step.

2018-02-05_144246-1024x540.png

Select Fetch Entities step again to configure FolderId input. Select Constant Mapping Type
In the resulting dialog pick the System Folder and select Ok .

2018-02-05_144341-1024x540.png

This completes the Flow. Select Debug Flow link from the top panel in the Flow Designer to test the Flow.

2018-02-05_144404.png

The Form opens in the Debugger and shows all Folders from the System Folder are displayed on the Data Grid component. Close the Debugger .

2018-02-05_145911-1024x540.png

Back in the Flow Designer , configure Fetch Entities step to filter fetched entities. In the step configurations, pick field and filter types. First, select folder Type Name as Field 1 .

2018-02-05_150635.png

Then, for the filter type select Equals .
Note that: a new Input for this step appeared. Configure this new input: folderInputType, as Constant with ‘Designer Project’ value.

2018-02-05_150752.png

In the same manner add second filter. This time select createdOnDate field and choose Less Than filter type. Then, configure createdOnDate input for this step.

2018-02-05_150836.png

2018-02-05_150904.png

Was this article helpful?