> For the complete documentation index, see [llms.txt](https://docs.xenioo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xenioo.com/actions-and-operations/database/set-field-filter-value.md).

# Set Field Filter Value

This action represents a field filter that can be applied to a [Query](/database/database-api-access/query-collection-1.md), [Load ](/actions-and-operations/database/load-single-record.md)or a [Delete ](/database/database-api-access/delete-from-collection.md)action

![](/files/-M_dik3nyR1cMv4Bs1St)

### Settings

The action uses the following settings:

| Setting                    | Description                                                                                  | [Parsed](/actions-and-operations/dynamic-parsing.md) |
| -------------------------- | -------------------------------------------------------------------------------------------- | ---------------------------------------------------- |
| Preceding Logical Operator | The logical operator to be applied to this filter when joining with the previous filter      | :no\_entry:                                          |
| Field Name                 | The name of the field                                                                        | :white\_check\_mark:                                 |
| Criteria                   | The criteria to be used for this filter                                                      | :no\_entry:                                          |
| Value                      | The[ ](/actions-and-operations/database/set-field-filter-value.md)value to be used to filter | :white\_check\_mark:                                 |

### Remarks

All filters, except Is Empty/Has Value apply only to records inside the collection that has the specified field. As an example, filtering for a field named *test*, containing *123* will exclude not only all records that do not have test containing *123* but also all records that do not have the field *test*.

If the Value field is left empty and Criteria is not Empty/Has Value, the criteria will be forced to Empty. As an example, setting a filter for "test is equal to" without specifying the value to check is identical to setting a filter like "test is empty or unset".

### Trigger

This action does not have any trigger.

### Variables

This action does not have any variable.

### Availability

Channel specific availability follows the table below:

| Channel          | Availability     |
| ---------------- | ---------------- |
| Facebook         | Fully Available. |
| WhatsApp         | Fully Available. |
| SMS              | Fully Available. |
| Telegram         | Fully Available. |
| Web              | Fully Available. |
| Alexa            | Fully Available. |
| Google Assistant | Fully Available. |
| Slack            | Fully Available. |
| API              | Fully Available. |

This action requires an active [Database ](broken://pages/-LdYpe93z-UqrvvQdX7V)package. This action can only be used as an operation for a [Query ](/database/database-api-access/query-collection-1.md), [Load ](/actions-and-operations/database/load-single-record.md)or [Delete ](/database/database-api-access/delete-from-collection.md)action.