# Set Field Filter Value

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

![](https://content.gitbook.com/content/tZEstFBYh3uMutlup6ku/blobs/hV1X59GkrLK709H9004Z/image.png)

### Settings

The action uses the following settings:

| Setting                    | Description                                                                                                             | [Parsed](https://docs.mylinkconnect.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://docs.mylinkconnect.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://docs.mylinkconnect.com/actions-and-operations/database/broken-reference)package. This action can only be used as an operation for a [Query ](https://docs.mylinkconnect.com/database/database-api-access/query-collection-1), [Load ](https://docs.mylinkconnect.com/actions-and-operations/database/load-single-record)or [Delete ](https://docs.mylinkconnect.com/database/database-api-access/delete-from-collection)action.