---
metadata:
  - name: generator
    content: Diplodoc Platform v5.56.0
alternate:
  - https://yandex.ru/support/wiki/en/actions/grid-reference.md
  - https://yandex.ru/support/wiki/ru/actions/grid-reference.md
  - href: en/actions/grid-reference.md
    type: text/markdown
    title: Markdown version
  - href: ../llms.txt
    type: text/markdown
    title: llms.txt
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.ru/support/wiki/en/llms.txt

# Dynamic tables

{% note info "" %}

For instructions on working with dynamic tables in the new editor, see [Dynamic table](https://yandex.ru/support/wiki/en/wysiwyg/grid.md).

{% endnote %}

<!-- source: en/_includes/actions-alert.md -->
{% note warning "" %}

Dynamic blocks are fully compatible with dynamic tables and any pages created in the [legacy editor](https://yandex.ru/support/wiki/en/pages-types.md#page).

<!-- source: en/_includes/old-editor-note.md -->
You can no longer create pages using the old editor. 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](https://yandex.ru/support/wiki/en/page-management/convert-page.md).
<!-- endsource: en/_includes/old-editor-note.md -->

{% endnote %}
<!-- endsource: en/_includes/actions-alert.md -->

Using the `grid` block, you can embed a [dynamic table](https://yandex.ru/support/wiki/en/wysiwyg/grid.md) in your page and set up its format.


### Using the block {#tab-call}

```
{{grid page="<table_address>"}}
```


### Block parameters {#tab-params}

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:<br>`{{grid page="<table_address>" width="60%"}}` |
| `readonly` | If specified, the table is embedded in <q>read-only mode</q>. |
| `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](#row-filter). |
| `columns` | Use it to [set columns to display on the page](#col-filter). |

## Setting filters for displaying rows {#row-filter}

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 ![](../_assets/svg/actions.svg)</svg> in the column header.

* Select ![](../_assets/svg/settings.svg)</svg> **Settings**.

To output all rows that meet at least one of the specified conditions, use the `OR` operator.

{% cut "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.<br><br>For logical 0: `no, off, false, unchecked`.<br><br>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 |

{% endcut %}

{% cut "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')` |

{% endcut %}

## Choosing columns to display {#col-filter}

You can only display the specified columns of a dynamic table on a page. To do this:

1. Get the table embed code and insert it into the text of the page.

1. Add the `columns` parameter 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 ![](../_assets/svg/actions.svg)</svg> in the column header.

* Select ![](../_assets/svg/settings.svg)</svg> **Settings**.
