# Set Field Filter Value

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

![](https://2678899722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPD9c4fJbXSAZcPHt9%2F-M_dhtt6_NihayF6tXlK%2F-M_dik3nyR1cMv4Bs1St%2Fimage.png?alt=media\&token=981a01b0-ccd9-4535-b4be-1c24433136ad)

### Settings

The action uses the following settings:

| Setting                    | Description                                                                                                        | [Parsed](https://docs10.xenioo.com/actions-and-operations/dynamic-parsing) |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------- |
| 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[ ](https://docs10.xenioo.com/actions-and-operations/database/set-field-filter-value)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 ](https://docs10.xenioo.com/basic-concepts/your-account/additional-packages)package. This action can only be used as an operation for a [Query ](https://docs10.xenioo.com/database/database-api-access/query-collection), [Load ](https://docs10.xenioo.com/actions-and-operations/database/load-single-record)or [Delete ](https://docs10.xenioo.com/database/database-api-access/delete-from-collection)action.