Flow Help
NovacuraRoadmap
6.11
6.11
  • What is Novacura Flow?
  • ๐Ÿ““System requirements
  • ๐ŸŽ‰Release notes
  • ๐ŸŽฃGetting started
    • Quick start
    • Develop your first app
  • ๐Ÿ”จInstallation and upgrade
    • Installation
    • New installation
    • Upgrade installation
    • Apply service pack
    • Add component
    • Windows authentication
    • Event log
    • FAQ
      • Monitoring
      • Troubleshooting
      • Migration tool
      • IIS user permission
      • Moving SQLite portal database
  • ๐ŸงฑSecurity
    • Server
      • Security settings
  • ๐Ÿ’กDevelopment
    • Studio
      • Installation and log in
        • OpenID connect
      • Applications
        • Menu
          • Inbox
        • Workflow
          • Start step
          • User step
            • Header
            • Static text
            • Labeled static text
            • Link
            • External app launcher
            • Image viewer
            • Text input
            • Numeric input
            • Date input
            • Time input
            • Check box input
            • Binary option input
            • List selection input
            • List multi-selection input
            • Menu selection input
            • Image selection input
            • Data grid
            • Calendar
            • List presentation
            • Camera input
            • File gallery
            • GPS location input
            • Signature capture input
            • Item creation sub task
            • Check list sub task
            • Verb sub task
          • Machine step
          • Decision step
          • Assertion step
          • Assignment
          • Table
          • Checkpoint
          • Split
          • Join
          • Script item
          • Log point
          • Annotation
          • End step
          • Included workflow
          • Offline resource
          • Public variables
          • Swimlanes
          • Offline workflow
            • Create an offline workflow
            • Create an offline resource
            • Create an offline seed inbox
            • Create an offline transactions
        • Subscribe
        • Server content
          • Workflow scheduler
          • Generate link
        • Elements
        • Problems
        • Find
        • Metadata panel
        • Version panel
        • Navigation
        • Test bench
        • Application package
          • Get started
      • Environment
        • Users
        • Roles
        • Connectors
        • Properties
        • Languages
        • System events
        • Active directory sync
        • License
        • Devices
        • Branding
        • Reports
      • Monitoring
        • Tasks
        • Applications
        • Help requests
      • Connectors
        • Business systems
          • Database
          • IFS Applications
          • Infor M3
            • M3 Infor API
            • Infor M3 REST
          • Maximo Generic
          • SAP
            • SAP BAPI
              • Basic API
                • BAPI: ZNCFLOW_APPLICATION_COMPONENT
                • BAPI: BAPI_MONITOR_GETLIST
                • BAPI: BAPI_INTERFACE_GETDOCU
                • BAPI: RFC_GET_FUNCTION_INTERFACE
                • BAPI: ZNCFLOW_DDIF_FIELDINFO_GET
          • Oracle Primavera
          • Microsoft Dynamics AX
          • Microsoft Dynamics CRM
          • Microsoft Active Directory
          • Microsoft SharePoint 2013
            • Generic operations
              • Custom list
                • Attachments
                • Create new item
                • Create new item, with field values
                • Delete item
                • Get items by query
                • List all items
                • List fields of items
                • Update item field
              • Document library
                • Check in/out file
                • File management
                • Create sub folder
                • Upload/download
              • Tasks
                • Attachments
                • Predecessors
                • Task information
                • Update task
                • Create new subtask
                • Create new task
              • User operations
                • Group operations
                • Get user by ID
                • Get user by login name
                • List users
        • Communication
          • Email
          • Web page submit
          • FTP
            • Server Operations
            • Directory operations
            • Download Operations
            • File Operations
            • Upload operations
          • SFTP
            • Directory operations
            • Download operations
            • File operations
            • Upload operations
          • Modbus
            • Read operations
            • Write operations
          • External Oauth 2.0 provider
          • Siox
          • REST service
            • REST Project Tool
              • Global output
              • Global parameters
              • Authorization schemes
              • Model transform
              • Enumerations
              • Models
                • Custom model member
              • Operations
                • Parameters
                • Outputs
              • Getting started
          • Web service
            • Example
              • Webservice example: Connector to Microsoft Dynamics AX
        • Printing
          • BarTender 2016
            • Print
            • Manually select
            • Print from BTXML script
            • Print from BTXML script
            • List printers
          • NiceLabel
          • Html to PDF
        • Utility
          • Flow environment
          • Table Operations
          • Custom .NET
          • Google API
          • Generate Xml Data
          • Generate text
          • File System
            • Directory operations
            • File operations
            • Zip operations
      • FlowScript
        • Variables
        • Operators
        • Functions
          • Text functions
          • Number functions
          • Date functions
          • Advanced functions
        • Table
          • Table functions
        • Programs
        • Formats
        • Script examples
        • AD sync scripting
    • Portal 2
      • Getting started
      • General
        • Add pages and portlets
        • Edit pages
        • Navigation
        • Style
        • Settings
          • List of values management
          • Presentation mode
      • Portlets
        • Chart portlets
          • Column chart
          • Line chart
          • Pie chart
        • Data tree
        • Document viewer
        • Filter
        • Html table
        • KPI portlets
          • KPI card
          • Speedometer
        • Record viewer
        • Table
        • Text
        • Common configuration
    • Portal
      • Get started
      • Options
        • Settings
        • List of values management
        • Global variables management
        • Content access management
        • Translations management
        • Import/export
      • Portlets
        • Table
          • Database source
          • Workflow source
        • Record viewer
        • Process overview
        • Iframe
        • Inbox
        • News viewer
        • Document tree
        • Document list
        • Document viewer
        • Generic document viewer
        • Generic document viewer URL
        • Generic document viewer
        • Filter
        • HTML
        • Text
        • Data visualizer card
        • Data visualizer navigator
        • Visual planning
          • Gantt chart
          • Kanban
          • Resource bucket
          • Scheduler
        • Map
      • Portal Push
      • Icons
  • ๐Ÿ“ฑClients
    • Android legacy client
    • iOS client
    • Windows 10 client
    • Web client
    • Windows CE client
  • โ“FAQ
    • How do i find which version of Flow i am running?
  • ๐Ÿ“งContact
Powered by GitBook
On this page
  • General
  • Listeners
  • Data
  • Data source
  • Columns
  • Default presentation
  • Edit operations
  • Interaction
  • Quick action
  • Custom button
  • Row color rules
  • Style
  • Table Usage
  • Column rearrangements
  • Sorting
  • Filter
  • Export to Excel
  • Full screen

Was this helpful?

  1. Development
  2. Portal 2
  3. Portlets

Table

PreviousRecord viewerNextText

Last updated 5 years ago

Was this helpful?

The Table portlet displays data from databases as a table by executing SQL queries. Columns can be configured in the table portlet editor to customize how the data is displayed. Table portlets can be exported as a Microsoft excel file (.xlsx), and can run machine and user workflows by pressing a preconfigured or customized button.

General

General data is required for all portlets.

Listeners

The portlet can listen to the following commands:

  • On Row Selection

  • On Filter

  • On Refresh

Data

Data source

The portlet 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: uses a flow connector to retrieve data from a database

  • Workflow: runs a workflow to retrieve data

Columns

Click Execute in the data source section to fetch the columns. Each column can be configured with:

  • display name

  • column type

  • whether the column should be visible

  • whether the column should be editable

There are a number of column types to choose from. The default column type is text.

  • Text: use to display column as a text fields

  • Number: use for number fields where the number is an integer

  • Decimal: use for number with decimals

  • Date: will display the column as a date with no time

  • Date & time: use to display date and time

  • Checkbox: the column field will be a check box

  • List of value: connect the column to a list of value, which will be a drop down list in the column field. Click the Manage button to go to Manage lists of values. Follow the link below to read more about lists of values.

Default presentation

  • Sort by: choose whether sorting should be by a specific column and/or if sorting should be in ascending or descending order

  • Rows per page: set the number of rows shown on each page, and use pagination to go to the next page. Note: if the portlet size is smaller than the number of rows to be shown, the portlet will get a scroll bar.

Edit operations

Edit operations is used to connect actions, such as creating, updating and deleting workflows through the portlet. The workflows can be either user or machine type.

Tick allow selection of multiple rows to enable selection or more than one row in the table. Use the Shift key to select multiple rows.

Click the drop down to select an existing workflow or New to create a new one. In Supported Actions, tick the actions the workflow is to perform: create, update, or delete.

The variables sent to the workflow needs to be specified in start step:โ€Œ

  1. Table with table name specified in output.

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

  3. Type variable which contains the action create, update and delete.

Click New to create a new workflow. A text box will pop up. Fill in the name of the workflow. Use Add, Map and Remove All to add the workflow input parameters.

  • Add: add a user-defined column

  • Map: adds all selected columns

  • Remove All: removes all columns

Interaction

Quick action

A quick action is a row-specific action available to the user by clicking the cog wheel in the first grid column. The row data is sent as in-parameters to the workflow and can be picked up in the start step (and thus used in the workflow).

The quick action workflow is added by selecting a workflow from the drop-down list.

Custom button

Custom button is used to enable access to workflows in the portlet. The button will be placed in the portlet header.

Click New to add a custom button. Enter the button name: this text will be displayed on the button in the portlet. Select the workflow which is to be connected to the custom button from the drop-down list.

Configure when the custom button should be enabled:

  • Always: the button is always available

    • if no rows are selected in the table, an empty data set is sent to the workflow

    • if one ore more rows are selected, this data will be sent to the workflow

  • Condition: the button is enabled if the condition is true for ALL selected rows

    • the selected row data is sent to the workflow

Row color rules

Alternate row color sets every other row to a a default light grey color in order to make the table row visualization better. The color can be configured by clicking on the color box and selecting a color.

The table rows can have one or more color rules. To enter a new rule:

  • click New

  • select a color

  • enter the condition field, operator and value

  • preview the result or save

To edit an existing rule, click on the rule and it expands into edit mode.

Style

Change the header text color and add a header stripe by configuring style.

Table Usage

The following sections briefly explain how a user can interact with the table portlet in the Portal.

Column rearrangements

The user can rearrange columns if preferred by dragging and dropping from the columnโ€™s header.

Sorting

The user can choose to sort the data in the table by either clicking directly in the header cell or by clicking on the column menu and selecting the appropriate sorting.

Filter

The user can choose to filter the data in the table to show requested data. The filter is accessible from the column menu by choosing Filter. The user can then choose the appropriate filter operator and value to filter on.

Export to Excel

If the table portlet has been configured to allow exports, the user can choose to export the table data to Excel by clicking on the export button in the top right corner of the table portlet. The user is then given the choice to either export all of the data results, or the results from the specific page in the table.

Full screen

By clicking the full screen button in the top right corner of the table portlet, the table portlet can be viewed in full screen.

๐Ÿ’ก
List of values management
General configuration
Listeners configuration
Data source configuration
Workflow source configuration
Style configuration