Creatio base
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Applying the advanced filter with grouping filter conditions

You can create advanced filters with several logical operators. For example, you can display all customer accounts who reside in New York, and those that have no city specified:

1.Open the Accounts section. From the [Filter] menu, select the [Switch to advanced mode] option (Fig. 1).

2.Apply the “Type = Customer” condition:

a.Click the <Add condition> link.

b.In the opened window, select the account column, for example, “Type”. Click the [Select] button.

c.In the filter setup area, click the <?> link. In the opened window, select the needed value for the selected column “Category = VIP”. Click the [Select] button.

3.Add the “City = New York” condition in the same manner.

4.To apply the “City is not filled in” condition:

a.Click the <Add condition> link.

b.In the opened window, select the “City” column. Click the [Select] button.

c.In the filter setup area, click the condition type and select the “is not filled in” condition from the menu.

5.Group the needed conditions and set a different logical operator for them:

a.Holding down the Ctrl key, select the conditions to group (Fig. 1).

Fig. 1 Selecting filter conditions to be grouped

scr_filters_advanced_filter_select_conditions.png 

b.From the [Actions] menu, select the [Group] option (Fig. 2).

Fig. 2 Grouping filter conditions

scr_filters_advanced_filter_group.png 

As a result, the selected conditions will be combined in a separate group.

c.Set “AND” as the logical operator of the root group and “OR” as the logical operator for the newly created group by clicking the operator name (Fig. 3).

Fig. 3 Setting a logical operator for the group of filter conditions

scr_filters_advanced_filter_group_operator.png 

6.Click the [Apply] button.

As a result, only the accounts of the “Customer” type for which the “New York” value or no value is specified in the [City] field will be displayed in the section.

See also

Applying an advanced filter by object columns

Applying an aggregate filter

Applying filter by time period

Did you find this information useful?

How can we improve it?