The table portlet can show data from databases as a table by executing SQL queries. It is possible to configure the columns in the table portlet editor to customize how the data is displayed. The portlet can export the table as a Microsoft excel file (.xls) and run machine and user workflows by pressing a preconfigured or customized button.

Basic data

Internal name - unique string to identify this portlet. Portlet title - title of the portlet, does not have to be unique.

Checkbox options

• Read only - enable that data cannot be modified.

• Groupable - group data in table by selected column.

• Multi Select - enables hold SHIFT to select several rows.

• Reordarable - enables to adjust in which order the columns are ordered by drag and drop.

• Resizable - enables to adjust the width of the columns.

• Exportable - enables a button to export the data as a Microsoft Excel File (.xls).

Auto Refresh

Enables the portlet to refresh the data every SS:second. If data has changed in the columns the table wont refresh until the changes are saved or canceled.

Self-Hosting Flows

Enables the portlet to continue running when the user reaches for another portlet.

Commands

Commands enables the portlet to listen for events sent by other portlets to execute specified commands. The portlet will listen to the following commands

• onRowSelected

• onGenericTreeNodeSelected

• onRefresh

• onFilter

The portlet will listen to the following portlets Specify which portlet the commands above will trigger from. The portlets that appears will be shown with their unique internal name.

Show rows when onRowSelected empty - todo

Data Source configuration

Data source configuration enables the portlet to execute specified queries towards the chosen database connector to fetch data, or fetch data from a workflow.

Database option queries a database through a flow db connector to retrieve data. Database source

Workflow option allows for any type of data table to be retrieved as data that the portlet can show. Workflow source

Flow Configuration

Flow Configuration enables the portlet to add machine and user workflows. The variables that are sent to the workflow that needs to be specified in start step are:

1. Table with table name specified in output.

2. All columns to be specified as variable inside the table

3. Type variable which contains the text "update", "add", "delete"

There are three kinds of workflows that can be used in the Table portlet:

1. CRUD Workflow - This option executes changes that have been made in the table (UPDATE, CREATE, DELETE) to an attached machine workflow.

2. Double Click Workflow - This option enables a button that runs Machine Workflows, if User Actions is checked you can also choose User Workflows.

   • Note when this option is checked, data will be sent as a table parameter named DblClickRow

3. Custom Workflows - This option can be linked to a custom button attached to the table. Machine workflows cannot be used here.

   • Note: Left Value can be values e.g. {VALUE IN COLUMN} from the sql query where Dataset is the specified column.

User Action checkbox enables the portlet to add user task workflows.

Color Rule Configuration

Configure coloring rules on the table rows.

Color rule setup

• First value - variable.

• Func - parameter to consider.

• Second Value - the value to be measured against the variable.