CMS

Filters

9min

Filters are used by multiple HyperPortal features, they allow to display/get/modify content depending on set conditions.

Settings

ALL/ANY condition

With this setting, you can decide whether all conditions should be met or only one.

Example - let`s create two conditions for the list view of the contact entity. The first condition - the country is Belgium. The second condition - gender is female.

Document image


If 'ALL' is chosen, only contacts that meet two conditions will be displayed.

Document image


If we click on 'meet any of the following conditions' the system will display contacts that meet any of the conditions.

Document image

Document image


Condition groups

The group of conditions allows us to use multiple conditions as one single condition.

Next to the 'add condition' button, there is an 'add group' button. Instead of one condition, you can add a group of conditions.

Document image


Inside the condition group, you can add other conditions or groups.

Document image


Group conditions are useful when you want to display/get/modify multiple groups of items. For example, I can create a filter that shows me blue diesel cars and red electric cars. First I need to create two groups.

Document image


The first group will contain conditions for blue diesel cars, and the second group will contain conditions for red electric cars. For the main filter, we should select 'meet any conditions', so the cars from each group will appear. We should also select 'meet all' in each group.

Document image


The result of this filter will show two groups of cars.

Document image


"Is Any Of" and "Is Not Any Of" operators:

We have added new filter options, "Is Any Of" and "Is Not Any Of" with support for bulk pasting.

Rules:

  • These filter operators work with the following property types: plain text, Entity, Phone, Email, and Link.
  • Item Limit: Supports up to 1,000 items in the filter.
  • If you input more than 1000 items in the field, then the remaining items will be copied to the clipboard
  • If the filter exceeds 1000 values, the "+ Add condition" button will be disabled
Document image




For the Safari browser, the "Copy" button was added, in other browsers the values that exceed 1000 are automatically added to your clipboard after pasting:

  • Warning notification popup
Document image




  • Error notification popup
Document image


Use case example:

1. Copy the items from the "country" column in your Excel file.

Document image


2. In HyperPortal, click the "Edit View" button.

3. Add a filter for the entity property "Country" (1) and click on the dropdown where you can choose

  • "Is Any Of" - the table displayed only items that were added to the filter (2)
  • "Is Not Any Of" - the table displays all elements except those added to the filter (2)
Document image


4. Paste the copied "Country" values into the "Search Country" field.

Document image


5. Click the "Show Result" button to apply the filter.