Celonis Product Documentation

resizeMode

true

Boolean

fit

expand (default)

Defines how table columns should be spaced and behave as users resize them. The two options are:

Expand to fit content:

Fit to table width:

allowContentLineBreak

true

Boolean

true

false (default)

Defines if long text should appear in multiple lines in column cells.

allowHeaderLineBreak

true

Boolean

true

false (default)

Defines if long text should appear in multiple lines in column headers.

selectable

false

Boolean

true

false (default)

Defines that checkboxes are displayed in the first column. This is required for displaying default actions above the table.

showPagination

false

Boolean

true (default)

false

Defines if paginations at the bottom of the table should be displayed. Infinite scrolling will be used if pagination is not defined or set to "false".

stickyFirstColumn

false

Boolean

true

false (default)

Defines if the first column should be sticky while scrolling horizontally through the table.

stickyLastColumn

false

Boolean

true

false (default)

Defines if the last column should be sticky while scrolling horizontally through the table.

allowDataExport

false

Boolean

true

false (default)

Defines end users can export the table as CSV or XLSX. Keep in mind that the download might take some time depending on how much data gets exported. The export button will be greyed out while the export is running.

When using this configuration also make use of the "name" attribute. Otherwise the layout won't look good.

density

false

Boolean

standard (default)

compact

relaxed

Defines if the table should be shown with a standard, relaxed, or compact view by changing the row height.

Standard

Compact

Relaxed

onEdit

Defines if the column should enable inline editing.

This feature is only currently available for augmented attributes

executeSkill

false

skillKey

-

Defines if a skill should be executed when any augmented attribute is updated in the table. You can create a skill and link to the column using the skillKey. For additional details on setting up an automation check out this document.

When creating the skill for this configuration, you can use the inputs "NEW_VALUE" and "IDENTIFIER" if you wish to include these in your skill (E.g. Send email notification with updated value to customer)

Create a manual sensor with the following inputs:

NEW_VALUE

IDENTIFIER

updateAugmentedAttribute

false

Boolean

true

false (default)

Defines if in-line editing should be enabled. Additional details on how to set this up can be found here.

This can only be used for augmented attributes. Additional details on augmented attributes can be found here.

Click here to see screenshot:

data:
  columns:
...
...
   - field: PIZZA.TYPE
     id: df08a98d-812d-4008-ae80-583375530f0e
     order: 400
   - field: PIZZA.SIZE
     id: 3730ffb3-9e5b-40c2-85cc-f3d1c852e6d4
     order: 500
   - field: PIZZA.AUGMENTED_CATEGORY
     id: 8f04b729-cbbd-4185-8735-ada87bba5228
     order: 600
   - field: PIZZA.AUGMENTED_COMMENT
     id: c41d4c95-933d-47b3-81e7-256b2b1a50b9
     order: 700
     onEdit:
        updateAugmentedAttribute: true

onClick

Defines that the column should be displayed as link.

openView

Defines the view that will open onClick. You can link a Profile View (using the profileView selector) or any other view (using the viewKey)

profileView

false

Boolean

true

false (default)

Defines if a link to the record profile should be added. For more information, see Linking Tables to Profile Views.

viewKey

false

view key

-

Defines the view the user wants to link to the table column using the View's Key.

showInSideOverlay

true

Boolean

true

false (default)

Defines if a modal gets opened or a slide in will appear.

Default Slide in (true)

Modal (false)

syncFilters

false

String

forward-only (default)

backward-only

disable

both-ways

Defines if and how view filters are synced between the main view and any linked view. This will apply to all filters applied to the view (i.e. applied from dropdowns, quick-filters, charts, etc.)

forward-only: Filters set in the main view will be immediately applied to any linked view. 

backward-only: Filters set in the linked view will be immediately applied back to the main view. 

both-ways: Filters set on the linked view are immediately applied to the main view and filters set on the main view  are immediately applied on the linked view. 

disabled: no filters are carried to or from linked views. 

carrySelections

false

Boolean

true

false

Defines if table selections should be carried from the current view to the linked view. This should only be enabled if both your current and linked view contain table components.

hrefAttribute

false

Record.Attribute

-

References a KM record, which contains a URL. This can be used to generate dynamically URLs, which depend on the information from the individual table row.

SET-UP STEPS

1.) Create a new Attribute, which contains the URL structure inside pql attribute

Knowledge Model

      - id: HREF_USERNAME
        displayName: Href Username
        pql: '''https://www.google.com/?q='' || "PizzaP2P-fixed_xlsx_Sheet_0"."USER_NAME"' 
        #Defines URL structure
        filterIds: []
        columnType: string

2.) Enable hrefAttribute for your table

View

- id: table
    type: table
    settings:
      data:
        columns:
          - field: ACTIVITY.CASEKEY
                        order: 100
            id: baffa132-b23a-4470-b2b6-36b069e6f893
            onClick:
              hrefAttribute: ACTIVITY.HREF_USERNAME #References attribute from KM
              openInNewTab: true 
              #Define if the URL should be opened in a new tab or not. Default: false

openInNewTab

false

Boolean

true

false (default)

Defines if the URL should be opened in a new tab or not. This configuration only works if you also use hrefAttribute.

update

variable:

- name: variable1

- name: variable2

false

View Variable

Package runtime Variables

-

You can use a table to update a variable upon clicking a link in a row of your table. This allows you for example display the details of a specific line item right underneath the table component, instead of opening it in a separate profile view.Click here to learn more about the concept of variables here.

View

variables:
  - name: demo #Defines demo variable.
    defaultValue: demo text
...
components:
  - id: table1
    type: table
    settings:
      data:
        columns:
          - order: 100
            field: ORDERS.ORDER_ID
            id: 893b4d4a-37e3-400a-af89-13692a9cf2f1
            onClick:
              linkToRecordProfile: true
            showTasks: true
          - order: 150
            field: ORDERS.CATEGORY
            id: 149e396e-37ad-4d6b-a877-74fafb14ba88
            onClick:
              update:
                variables:
                  - name: demo #Sets demo variable when the user clicks on the row. 
  - id: text
    type: task-list
    settings:
      name: ${demo.ORDER_ID} #Displays the ORDER_ID of the variable demo.

showAlerts

false

Boolean

true

false (default)

Defines that Alerts are displayed in the column. It can be used to inform a user about a potentials issue. For more details on how create alerts check out the following documentation.

hide

false

Boolean

true

false (default)

Defines if the column should be hidden or not. This configuration can be used in combination with allowInvisibleColumns: true (see above). By this columns are not visible by default but customers can still choose if they would like to have certain columns visible in their table.

copyToClipboard

false

Boolean

true

false (default)

Defines to allow copy to clipboard functionality when hovering the cell in this column.

displayContentRule

false

Custom Attribute

Defines custom formatting of individual attributes. You can change text formatting or apply icons based on different conditions. For more details check out the Display Rule documentation.

limit

false

Integer

Defines how many rows should be displayed per page.

Click here to see screenshot

distinct

false

Boolean

true

false (default)

Defines if only distinct values are displayed. It works only when options selectable, link, showTasks, showAlerts and task attributes are not enabled.

sortBy

- field: RECORD.ATTRIBUTE

false

Record.Attribute

-

Defines the default sorting of the table. It requires to define the field and which direction the table should be sorted. Multi-column sorting is possible.

Sorting by KPI and Augmented Attributes is currently not supported.

Click here to see screenshot

direction: 

false

String

ASC

DESC

interactions: 

     filters:

false

Boolean

TRUE

FALSE

Defines if the table will be filterable via cell selections or not. 

breakdownSelector:

columns:

-field

false

Record Attribute, KPI, Augmented Attribute, or Custom Object

-

Defines if the user will have a breakdown selector shown in their table. This breakdown selector will allow users to change the dimension that the data is aggregated by in the table. 

The fields shown in the Breakdown selector can either be defined by listing the fields within the component or referencing a Custom Object. Both examples can be seen below: 

Fields defined in component: 

id: table-d2d7e5fc-3251-48a4-a861-63aafaf86d76
type: table
settings:
  data:    
    breakdownSelector:  
        columns:    
        - field: ORDERS.CUSTOMER_ID     
        - field: ORDERS.CUSTOMER_NAME  
        columns:    
        - field: ORDERS.PRODUCT_NAME      
          id: 3e68b67d-b460-4ec9-9059-568fb808e03e      
          order: 100     
        - field: ORDERS.PROFIT      
          id: dade401a-25ea-485b-a3b4-11f5911e34f5       
          order: 200    
        - field: ORDERS.QUANTITY     
          id: b20417cd-8af3-431c-ae10-a75214960efd     
          order: 300 
 name: Customer Details	

Fields defined by Custom Object from Knowledge Model: 

id: table-d2d7e5fc-3251-48a4-a861-63aafaf86d76
type: table
settings:
  data:    
    breakdownSelector:  
        customObject:KPI_Display_Rule