What are the different conditions in Filter?

Created by Alan Chris, Modified on Tue, 1 Apr at 3:57 PM by Alan Chris

What are different condition in Filter

1 : Field Conditions

Filter Condition	Description	Examples
is equal to	Matches values that are exactly the same as the filter value.	status is equal to "Approved"
is not equal to	Matches values that are different from the filter value.	status is not equal to "Rejected"
is greater than	Matches values that are larger than the filter value.	lead_value is greater than 10000
is greater than or equal to	Matches values that are larger than or equal to the filter value.	lead_value is greater than or equal to 5000
is less than or equal to	Matches values that are smaller than or equal to the filter value.	lead_value is less than or equal to 5000
is less than	Matches values that are smaller than the filter value.	lead_value is less than 10000
contains	Matches values that include the filter value within them.	feedback contains "urgent"
does not contain	Matches values that do not include the filter value.	feedback does not contain "spam"
ends with	Matches values that finish with the filter value.	email_address ends with "@example.com"
doesn't end with	Matches values that do not finish with the filter value.	email_address does not end with "@spam.com"
starts with	Matches values that begin with the filter value.	phone_number starts with "+1"
doesn't start with	Matches values that do not begin with the filter value.	phone_number does not start with "+44"
is	Matches values that are the same type as the filter value.	price is of type "number"
is not	Matches values that are not the same type as the filter value.	date_of_birth is not of type "string"
is empty	Matches values that have no content.	comments is empty
is not empty	Matches values that have some content.	comments is not empty

2 : Group Conditions

"Match All" and "Match Any". These conditions are crucial for determining how the applied filter criteria will interact with each other to refine and sort the data you’re working with.

1. Match All Condition (AND Logic):

The "Match All" condition, also known as an AND logic, applies filters in a way that only records that satisfy every condition you set will be shown. It's a more restrictive condition and is useful when you want to find records that meet all of the specified criteria.

How it Works:

When you apply multiple filters, the "Match All" condition requires that all of them be true for a record to be included in the filtered results.
This means that only the records that meet every single condition will be displayed.

When you choose "Match All", Konnectify will return only the records where:

The order value is greater than $500.
The order was placed from California.
The order was placed within the last 30 days.

In this case, only the orders that meet all three conditions will appear in the results. If a record satisfies only one or two of these conditions but not all, it will not be included in the results.

Benefits of "Match All":

Precision: Ensures that your data is extremely relevant to your exact needs, narrowing down the results to highly specific records.
Clear Focus: Great for focused searches where you need results that meet a combination of conditions.

2. Match Any Condition (OR Logic):

The "Match Any" condition, also known as an OR logic, applies filters in a way that records meeting at least one of the conditions will be included. This is a more flexible condition and is useful when you want to cast a wider net and include records that satisfy any of the criteria you set.

How it Works:

When you apply multiple filters, the "Match Any" condition will return records that meet at least one of the conditions, regardless of whether they meet the others.
This is a less restrictive option compared to "Match All" and allows for more inclusive results.

When you select "Match Any", Konnectify will return records where:

The order value is greater than $500, regardless of the location.
The order is from California, regardless of the order value.

In this case, the system will return orders that meet either of the two conditions, meaning if an order is from California but below $500, it will still show up in the results. Similarly, an order above $500 but not from California will also appear.

Benefits of "Match Any":

Flexibility: Allows for a broader range of results, especially when you’re exploring multiple potential conditions.
Inclusion of More Data: Great for situations where you want to keep your search results wider and more inclusive, not narrowing the scope too much.

Comparison of "Match All" and "Match Any":

Condition	How It Works	Example	Result Type
Match All (AND)	Requires every condition to be true.	Orders > $500 AND from California AND placed in the last 30 days	Only records meeting all filters.
Match Any (OR)	Requires any one condition to be true.	Orders > $500 OR from California	Records meeting at least one filter.

When to Use Each Condition:

Use "Match All" (AND) when you need highly specific and precise data. This is ideal when you have multiple conditions that must all be satisfied for the data to be relevant. For instance, if you only want sales records from a certain state and within a specific price range and within a certain time frame.
Use "Match Any" (OR) when you want more flexibility and want to include data that meets at least one of your conditions. It’s useful when you’re exploring broader possibilities or trying to capture data from a variety of sources or categories without excluding too much. For example, if you’re looking for sales data from either a certain price range or from a certain region, "Match Any" will let you gather a wider selection.
.