Dynamic tables
Note
For instructions on working with dynamic tables in the new editor, see Dynamic table.
Warning
Dynamic blocks are fully compatible with dynamic tables and any pages created in the legacy editor.
Creating new pages in the legacy editor is no longer possible.
However, you can easily convert any existing pages from the legacy editor to the new editor format. For more information, see Switching a page to the new editor format.
Using the grid block, you can embed a dynamic table in your page and set up its format.
Using the block
{{grid page="<table_address>"}}
Block parameters
You can set parameters for a table during the embedding process or change its code in markup mode.
| Parameter | Description |
|---|---|
page |
This is a required parameter. Contains the address of the table you want to embed. |
width |
Table width as a percentage of page width:{{grid page="<table_address>" width="60%"}} |
readonly |
If specified, the table is embedded in read-only mode. |
num |
If specified, row numbers are not displayed. |
sort |
If specified, the sorting settings of the source table are ignored. |
filters |
Use it to set filters for displaying table rows. |
columns |
Use it to set columns to display on the page. |
Setting filters for displaying rows
Use the filters parameter to set which rows should be displayed in the embedded dynamic table. For example:
{{grid page="<table_address>" filter="[id1]=<value_1>, [id2]=<value_2>"}}
This filter will only display the rows for which the following conditions are met at the same time:
-
Column with the
[id1]ID is set to<value_1>. -
Column with the
[id2]ID is set to<value_2>.
To find out the column ID:
-
Click in the column header.
-
Select Settings.
To output all rows that meet at least one of the specified conditions, use the OR operator.
Setting values to compare
Depending on the column data type, values to compare are specified in different ways:
| Data type | Example | Description |
|---|---|---|
| Text | 'bicycle' |
Text in single quotes |
| Number | -7 |
Number without quotes |
| Checkbox | true |
Different write formats are supported. For logical 0: no, off, false, unchecked.For logical 1: yes, on, true, checked, done. |
| Date | 2012-12-12 |
Date in YEAR-MONTH-DAY format |
| List | 'bicycle' |
Text in single quotes |
| Multiple-choice list | 'bicycle' |
Text in single quotes |
| Employee | login@ |
Employee's username without quotes |
| Issue in Tracker | KEY-1234 |
Tracker issue key without quotes |
Supported comparison operators
| Operation | Writes | Example |
|---|---|---|
| Equal to | =, is |
[13] is 'bicycle' |
| Not equal to | !=, is not |
[13] is not 'bicycle' |
| Comparison | <, >, <=, >= |
[13] > 50 |
| Contains a substring | ~ |
[13] ~ 'bi' |
| Contains no substring | !~ |
[13] !~ 'bi' |
| In the interval from ... to ... (handles numbers and dates) | between ... and ... |
[13] between 100 and 1000 |
| Equal to any of ... | in (...) |
[13] in ('bicycle', 'motorcycle', 'helicopter') |
| Not equal to any of ... | not in (...) |
[13] not in ('submarine', 'spaceship') |
Choosing columns to display
You can only display the specified columns of a dynamic table on a page. To do this:
-
Get the table embed code and insert it into the text of the page.
-
Add the
columnsparameter to the code to display only the columns you need:
{{grid page="<table_address>" columns="id1, id2, id3"}}
This dynamic block contains only columns with the id1, id2, id3 IDs.
To find out the column ID:
-
Click in the column header.
-
Select Settings.