# 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 ](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/broken-reference)tag in [form file](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/broken-reference).
2. Prepares and executes data block's query.
3. Executes ["post\_query" trigger](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/broken-reference) 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](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/broken-reference).

```
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](https://muradkarakas.gitbook.io/sodium_documentation/language-reference/built-in-functions/sodium-built-in-functions/other-functions/broken-reference).

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

{% endtab %}
{% endtabs %}