Common configuration
The configuration common for all portlets.
Last updated
The configuration common for all portlets.
Last updated
All portlets must have a name and a unique identifier.
Name: the name of the portlet
Unique identifier: unique string to identify this portlet.
Dynamic Titles
Dynamic titles can be used in portlet names to give more details of what is presented. For this to work, the portlet needs to have access to data as a parameter from the other portlets. To achieve this, let the portlet listen to other portlets.
To add a dynamic value to the title, add the parameter in the portlet's name using curly brackets - {}.
Example:
The title “Product info: {ProductId}” would display the chosen product id in the title given the parameter name is ProductId.
Auto-refresh: enables the portlet to refresh the data every SS:second
If data has changed in the columns, the table will not refresh until the changes have been saved or cancelled
Exportable: enables a button to export the data as a Microsoft Excel File (.xlsx)
Available for table portlet
Auto hide header: click to hide the header in the portlet
Database source uses a connector to fetch data to the portlet. Select the connector in the drop-down query and write the select statement in the space below the connector. The database type is visible at the top-right above the statement space, as is the expand icon (F11), which can be clicked to get a larger statement space.
When the select statement has been written, press the Execute button to make the select result available in the continued configuration.
Listeners enable the portlet to listen for events sent by other portlets to execute specified commands. Specify which portlet the commands should be triggered from by clicking in the From field. Select from the list of the available portlet's unique identifier. Click New if the portlet is to listen to more than one portlet. If using listeners, remember to adjust the data source query.
The following events are available:
On Row Selection
On Refresh
On Filter
Show rows when On Row Selected is empty: tick this box if the table portlet is listening to a portlet, but should show all data if no command is given—that is if no row has been selected in the commanding portlet. This option is only available for Oracle connectors.
On Filter event will be sent when filtering data by a Filter portlet when a filter is applied. The listening portlet will react to the filter and show appropriate data.
Example - list of values as filter
List of values select fetches part number and part description.
The query result is:
PartNo PartDesc
1013 Printer paper
1014 Rubber bands
1015 Ruler
List of values is set up to have PartDesc as the Text column and PartNo as the Value column. The list of values drop-down list will show the PartDesc (text column), and when selecting Printer Paper the part number 1013 will be sent as the value (value column) to filter on.
The column upon which the filter is to be applied is the Parameter in the filter configuration.
The event will be sent when a portlet is refreshed, either manually or automatically, and refresh listening portlets.
When selecting a row or item, this event will be sent to allow portlets to listen to this specific data.
Use curly brackets - {} to handle the data in the listening portlet. In the below example the portlet will only show data where PartNo equals the PartNo send in the selected row.
select PartNo, PartDesc
from part
where PartNo = {PartNo}
In Style, the user can set the color for portal title and add a color for a user-defined header stripe. The header stripe is visible between the table title and header sections.
Click on the color box to select the desired color.
Workflow data source fetches data to the portlet by executing specified flow studio workflows. Read more about how to work with workflows by clicking the link below.
WorkflowThe workflow data source fetches data, as the name implies, from a workflow.
If the workflow already has been created, select it from the drop-down. The workflow can be opened by clicking the Open button.
To create a new workflow, click the New button. Enter the workflow name, select if the workflow is to have paging and/or filtering, and click Create to save the workflow in the Studio. Click Open to launch the Studio and modify/finalize the workflow.
When a workflow is created from the Portal, the workflow will be automatically generated with Input and/or QuerySetting as start input data.
Input: enter the data or columns to be sent when communicating between two portlets, for example columns like ID and Value.
Query Settings: this contains necessary information for filtering, pagination, and sorting (only when using pagination and filtering).
Once the workflow elements have been added and finalized, configure the End Step to send data back to the Portal. 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.
To add output variables, open the End Step and tick the boxes for the output variables required to be sent to the Portal.
