advanced datatable
This block is part of the state ui group and was last modified in core v13.0.6.
Storage Selection Required
This block relies on a storage to perform its storage releated actions. You must manually select the storage you want to use in your flow using the storage selector modal. To access the modal, click the white button on the block.
advanced datatable v13.0.1 Updated v13.0.6A pre-styled advanced table showing data using advanced tooling
- state key
valueThe state to bind the datatable to. If it is updated, the component will re-render
- columns required
fielddefinitionsChoose the columns you want to show
- overwrite column titles
v13.0.8arrayOverwrite the title of a specific column.
- columns width
arrayChoose the widths of the columns in percentage, expects array of numbers. e.g.
5for5%in width. - columns sortable
fielddefinitionsChoose which columns can be sorted, by default we will not do any sortable fields
- overwrite column sort field
v13.0.8arrayOverwrite which field will be sorted on column sort. With this function it is possible to sort on non existing columns / fields that are made up by combining multiple different values or are returned by the row render.
- columns filterable
v13.0.7fielddefinitionsChoose which columns can be filtered, by default we will not do any filterable fields
- search fields
fielddefinitionsFields that will be searched on in addition to the column fields
- return fields
v13.0.8fielddefinitionsFields that will be returned during the search. Should be set if the data sent to the frontend should be limited due to confidential fields.
- row actions
statedatatableconnectionActions that are specific to the row like edit, detail, json, revision or inline edit
- query
queryQuery used as a base for the datatable
- show top pagination
v14.0.1conditionAdds a pagination to the top of the table
- rows per page
numberNumber of results per page in the table
- rows per page options
v13.0.8arrayOptions to show in the dropdown at the bottom right
- filters
statedatatablefilterAdds filtering to the datatable
- Storage
storage - class
uiclassAssigns a CSS class to the element. • Hidden when unused
- style
uistyleApplies inline CSS style to the element • Hidden when unused
- attributes
uiattributesAdds custom attributes to the element. • Hidden when unused
- state
stateReturns the element to the frontend state.
- Map Row
execute_functionThe function will be executed for each row and state pins can be returned to overwrite whats visible.
- Row Component
iteratestateThe component will be executed for every row and replace the default values and columns. A
trshould be returned. The available parameters arecolumns,rowandindex. - On change
v14.0.3execute_functionThe function will be executed every time any of the search parameters changes.
A typical wiring for advanced datatable: combine feeds the columns pin; the function out pin wires to an execute block.
Used in these guides
These documentation pages use or explain this block:
Version history
Introduced in v13.0.1.
Last modified in v13.0.6.
v14.0.3, click here to see the release notes. v14.0.1 This block or one of its pins was updated in v14.0.1, click here to see the release notes. v13.0.8 This block or one of its pins was updated in v13.0.8, click here to see the release notes. v13.0.7 This block or one of its pins was updated in v13.0.7, click here to see the release notes. Back to
state ui Return to the main group to view all sub-groups Back to state elements Return to the group to view all blocks within this group