# Filters

The filter is one of the most powerful features which helps you to filter the data coming from another app or the data stored within the picky assist and perform Actions based on the filter matching conditions,&#x20;

![](/files/-Ma-kv-HHdAZbKw67Z7T)

For example, if the age of the person is between 18-25 and the gender is male then perform a set of actions defined by you, similarly, you can create any number of filters and specify actions that are specified to the filters&#x20;

You can create Unlimited AND filter conditions and decide whether to match all conditions or match any conditions to perform the action in the step.&#x20;

**Match All Conditions**: If you select this then the system will match all conditions configured in the filter i.e all conditions should be true to take further actions

**Match Any Condition:** If "Match Any Condition" is selected then the system will proceed to the next step if any of the conditions in the filter becomes true.

{% hint style="danger" %}
Please note if the filter condition is false then it will skip the action configured in the step and moves into the next step in the order, so if you want to perform separate action for both filter conditions i.e true and false then please create another step with the false condition just below the true condition step
{% endhint %}

**Below are the available data types and conditions to filter**&#x20;

| Data Types                                     | Condition                                                                                                                                                                                                  |
| ---------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Text                                           | <p>is</p><p>isn't<br>in list<br>not in list<br>not</p><p>contains</p><p>doesn't contains</p><p>starts with</p><p>ends with</p><p>minimum length</p><p>maximum length</p><p>is empty</p><p>is not empty</p> |
| Numeric                                        | <p>equals</p><p>not equals</p><p>greater than</p><p>less than</p><p>between</p><p>not between</p><p>minimum length</p><p>maximum length</p><p>is empty</p><p>is not empty</p>                              |
| Date & Time                                    | <p>is</p><p>isn’t</p><p>on</p><p>after</p><p>before</p><p>not before</p><p>between</p><p>not between</p><p>is empty</p><p>is not empty</p>                                                                 |
| Date                                           | <p>is</p><p>isn’t</p><p>on</p><p>after</p><p>before</p><p>not before</p><p>between</p><p>not between</p><p>is empty</p><p>is not empty</p>                                                                 |
| Time                                           | <p>is</p><p>isn’t</p><p>on</p><p>after</p><p>before</p><p>not before</p><p>between</p><p>not between</p><p>is empty</p><p>is not empty</p>                                                                 |
| Email                                          | <p>is</p><p>isn't</p><p>contains</p><p>doesn't contains</p><p>starts with</p><p>ends with</p><p>is empty</p><p>is not empty</p>                                                                            |
| Website                                        | <p>is</p><p>isn't</p><p>contains</p><p>doesn't contains</p><p>starts with</p><p>ends with</p><p>is empty</p><p>is not empty</p>                                                                            |
| URL                                            | <p>is</p><p>isn't</p><p>contains</p><p>doesn't contains</p><p>starts with</p><p>ends with</p><p>is empty</p><p>is not empty</p>                                                                            |
| Choice                                         | <p>is</p><p>isn't</p><p>is empty</p><p>is not empty</p>                                                                                                                                                    |
| <p>WhatsApp <br>to Filter WhatsApp numbers</p> | <p>is</p><p>isn't</p>                                                                                                                                                                                      |

### In List & Not In List

Text filter has 2 additional conditions **"In List & Not In List"** which helps you to filter a group of text like postal code, email address, phone number, country code, country or any data which is separated by comma or any other delimiter, for an example, if you want to check assign the chat to different team members based on the postal code then you can make use of this feature, you can input all data in comma separated value like 898333,983333,898989,833333 and system will check the condition against the given data.

{% hint style="info" %}
If your data is not in comma separated format then you can instruct the delimiter to the system like pipe | etc&#x20;
{% endhint %}

#### Few Use Cases with this Filter&#x20;

1. When an order is received check whether the Postal code is serviceable or not and send a reply or take action accordingly&#x20;
2. Whitelist mobile numbers or email to give controlled access to certain information like a course or information only available to a group of white-listed email addresses or mobile numbers&#x20;
3. Allocate chat based on country to different team members like Asia assign to assign team, North America assign the chat to north America team&#x20;
4. Filter data based on a group of names like Daniel, Martin, Albert etc

### Date & Time Formatter&#x20;

There will be a situation when working with many 3rd parties that the date and time may not always be in ISO Standards so we have a date & time formatter which helps you to map the Day, Month, Year, Time, Hour, Format virtually from any type of formats when separated a record with a comma, hyphen, slash, dot, semi column&#x20;

You will also have the option to convert a date and time from a timezone to another which helps to send messages at the right time.

Date & Time formatter will appear when any of the Filter field type is Date, Date or Time, Time as show below&#x20;

![](/files/-Ma07kvlgnw5SXp11Vyc)

##


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.pickyassist.com/setting-up-guide/setting-up-connector/steps/filters.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.