Workflow source

Fetching data from workflows

When configuring the table portlet and want to fetch data from workflows one needs to first configure the settings in the portal, then inside the workflow.

Setting up workflow to fetch data from

Data source configuration enables the portlet to execute specified workflows to fetch data from the flow.

We introduce two types of data sources. Based on different use cases, they can be created in Studio or Portal using different machine workflow schemas.

• Data source with Pagination and Filtering - this a workflow where features like Pagination, Sorting and Filtering are being used on the data fetched from database or API connectors, it can also be applied when using table operations connector.

• Data source - this is a workflow which should return entire data set. For example all data from SQL table. Portal will automatically apply all parameters like pagination and filtering. This data source can additionally take Input parameter so data additionally can be filtered out (when a portlet is configured to listen to another portlet). When using Input parameter data is cached individually per user. If not, cached data is shared between multiple Portal users.

To be able to use workflows as data source one needs to: 1. Select a workflow from the list or add a new one on the add button. 2. Press open in Flow Studio

• Refresh - updates the list of workflows

• Open in Flow Studio - Opens the selected workflow in Flow Studio

• Add - Creates a new workflow, pop-up window for creating a workflow has Data source with filtering and data source without filtering, the workflow created will contain different preset input data and elements depending on which one is chosen.

Workflow Input Configuration

The input in the workflow will be automatically generated from the portal when creating a new workflow, what the input contains depends on what data is being sent and if its with filtering or not.

• Input - When communicating between two portlets this needs to be filled with the data/columns expected to be sent. Can be column names such as ID and Value.

• Query Settings - This contains necessary information for filtering, pagination, sorting(Only when using pagination and filtering).

These are added automatically when creating the workflow from the portal, what needs to be added on its own are the variables inside the Input table.

Workflow Data Source Configuration

After the input is configured machine steps fetching data can be added, all types of data sources are supported, both API connectors and database connectors.

Workflow Output Configuration

To send the data to the portlet the output data needs to be configured. The two important values that need to be sent are:

• TotalCount - the calculated total count(Only when using pagination and filtering).

• Single table variable - table variable with data that can be used by the portal. E.g a page from sql table.

These are added by opening the end step, pressing edit output variables and checking each variable that is to be sent to the portal.

Setting layout and settings for table portlet in portal

The Add and Map All Columns adds a column or all columns and their respective values to what is displayed in the portlet.

• Datasource Columns - A list of all columns fetched from the query.

• Column Name - Set the display name of that column.

• Width - How wide (in pixels) the column should be, leave blank to use default.

• Lov - List of values, only used when you created a list of values.

• Editor - Set what kind of data you can input into the column cells.

• Length - todo

• Editable - Checkbox if this column is editable or not.

• Hidden - Checkbox whether to show the column or not.