Dynamic tables
Alert
Dynamic blocks work in dynamic tables and on pages created in the old editor.
Using the grid block, you can embed a dynamic table in your page and set up its format.
Using the block
{{grid page="tableURL"}}
Block parameters
| 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="tableURL" 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="tableURL" filter="[id1]=value1, [id2]=value2"}}
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 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="tableURL" 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.