> For the complete documentation index, see [llms.txt](https://muradkarakas.gitbook.io/sodium_documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/refresh_block.md).

# refresh\_block

`refresh_block` function has 2 variants:

{% tabs %}
{% tab title="Variant 1" %}

#### Declaration <a href="#declaration" id="declaration"></a>

```
void refresh_block(char blockName);
```

#### Description

`refresh_block` function does sequentially:

1. Needs [datablock ](broken://pages/-M24IPFMzBTacW77y7BN)tag in [form file](broken://pages/-M246xLi4THzy9eme8bR).
2. Prepares and executes data block's query.
3. Executes ["post\_query" trigger](broken://pages/-M24Gd-_7blgf5jNIn0D) for each row.
4. Sends the new content of the data block to the client.

#### Parameters <a href="#parameters" id="parameters"></a>

`char blockName`

#### Return Value <a href="#return-value" id="return-value"></a>

#### Example <a href="#example" id="example"></a>

Reads all rows from database and shows them in [data block](broken://pages/-M24IPFMzBTacW77y7BN).

```
refresh_block('emps');
```

{% endtab %}

{% tab title="Variant 2" %}

#### Declaration

```
void refresh_block(char blockName, char whereClause);
```

#### Description <a href="#description-1" id="description-1"></a>

Same as Variant 1 except this version filter database rows stated in `whereClause` condition

#### Parameters <a href="#parameters-1" id="parameters-1"></a>

`char blockName`

`char whereClause`

#### Return Value <a href="#return-value-1" id="return-value-1"></a>

#### Example <a href="#example-1" id="example-1"></a>

Reads filtered data from database and shows them in [data block](broken://pages/-M24IPFMzBTacW77y7BN).

```
refresh_block('emps', 'department_id = ' || :Session.UserDepartmentId);
```

{% endtab %}
{% endtabs %}