Breadcrumbs

Filter on Properties

You can filter on properties of an event or object depending on the definition selection. You always need to select e definition first, who or what are you looking for.

You can filter on all properties part of the definition, per type you have different filter options. Each filter group you make has a result true or false and is taken into account on the main result.

Example 1. AND filtering

I am looking for all Persons who have an email on their profile.


  1. Select the Person definition

  2. You start with an AND filter, which may seem strange as it only has 1 filter, but underwater we perform a simple select query.

  3. Select a filter → properties

  4. Search for Email

  5. Add the filter type 'is not empty'

  6. Click apply

image-20250729-121010.png

Example 2. AND filtering

I am looking for all Persons who have an email on their profile and are from country 'The Netherlands'

  1. Click on the + sign to add another filter

  2. Country is part of the object 'Address details'

  3. Select Country equals 'The Netherlands'

image-20250801-120239.png

Example 3. AND filtering

I am looking for all Persons who have an email on their profile and are from country ‘The Netherlands' who gave 'Marketing consent’

  1. Click on the + sign to add another filter

  2. Select marketing consent with filter equals true (as the data type is a Boolean)

image-20250801-120407.png

Example 4. OR filtering

I am looking for all Persons who have an email on their profile and have given marketing consent OR have a Mobile phone number and have given marketing consent.

  1. Select the Person definition

  2. Select AND on main level

  3. As the marketing consent filter is present in both selections, you can set this on main level, all persons needs to have marketing consent

  4. Then add an OR group where the person needs to have either an email OR a mobile phone number

image-20250801-120518.png


Example 5. OR filtering

I am looking for all Persons who have an email on their profile and have given marketing consent OR have a Mobile phone number and have not given marketing consent.

  1. Select the Person definition

  2. Select OR on main level

  3. As the marketing consent filter is different in both selections, you cannot set this on main level, but need to make 2 groups that contain their dedicated filters.

  4. Add the 2 groups under the main OR

  5. Now OR block 1 is true OR block 2 is true. Persons who have and an email and marketing consent OR persons who have and a mobile phone number and no marketing consent.

image-20250801-120703.png

Example 6. Date filtering

I am looking for all Persons who’s birthday is today and have given marketing consent


Example 7. Date filtering

I am looking for all Persons who are 18 or older and have an email OR a Mobile phone number and have given marketing consent


Example 8. Date filtering

I am looking for all Persons who’s last purchase date is between now and 1 month in the past