Arrays and list functions arrays

Use these functions to make interaction with arrays, lists, and strings easier.

Count only null count-only-null

The countOnlyNull function is used to count the number of null values in a list.

Syntax

{%= countOnlyNull(array) %}

Example

{%= countOnlyNull([4,0,1,6,0,0]) %}

Returns 3.

Count With Null count-with-null

The countWithNull function is used to count all the elements of a list including null values.

Syntax

{%= countWithNull(array) %}

Example

{%= countOnlyNull([4,0,1,6,0,0]) %}

Returns 6.

Distinct distinct

The distinct function is used to get values from an array or list with duplicate values removed.

Syntax

{%= distinct(array) %}

Example

The following operation specifies people who have placed orders in more than one store.

{%= distinct(person.orders.storeId).count() > 1 %}

Distinct count with null distinct-count-with-null

The distinctCountWithNull function is used to count the number of different values in a list including the null values.

Syntax

{%= distinctCountWithNull(array) %}

Example

{%= distinctCountWithNull([10,2,10,null]) %}

Returns 3.

First item head

The head function is used to return the first item in an array or list.

Syntax

{%= head(array) %}

Example

The following operation returns the first of the top five orders with the highest price. More information about the topN function can be found in the first n in array section.

{%= head(topN(orders,price, 5)) %}

Sort and get first N in array first-n

The topN function sorts an array in descending order based on the given numerical expression and returns the first N items. If the array size is less than N, it returns the entire sorted array.

This function
Syntax

{%= topN(array, value, amount) %}

Example

The following operation returns the first five orders with the lowest price.

{%= topN(orders,price, 5) %}

In in

The in function is used to determine if an item is a member of an array or list.

Syntax

{%= in(value, array) %}

Example

The following operation defines people with birthdays in March, June, or September.

{%= in (person.birthMonth, [3, 6, 9]) %}

Includes includes

The includes function is used to determine if an array or list contains a given item.

Syntax

{%= includes(array,item) %}

Example

The following operation defines people whose favorite color includes red.

{%= includes(person.favoriteColors,"red") %}

Intersects intersects

The intersects function is used to determine if two arrays or lists have at least one common member.

Syntax

{%= intersects(array1, array2) %}

Example

The following operation defines people whose favorite colors include at least one of red, blue, or green.

{%= intersects(person.favoriteColors,["red", "blue", "green"]) %}

Sort and get last N in array last-n

The bottomN function sorts an array in ascending order based on the given numerical expression and returns the first N items. If the array size is less than N, it returns the entire sorted array.

Syntax

{%= bottomN(array, value, amount) %}

Example

The following operation returns the last five orders with the highest price.

{%= bottomN(orders,price, 5) %}

Not in notin

The notIn function is used to determine if an item is not a member of an array or list.

Syntax

{%= notIn(value, array) %}

Example

The following operation defines people with birthdays that are not in March, June, or September.

{%= notIn(person.birthMonth ,[3, 6, 9]) %}

Subset of subset

The subsetOf function is used to determine if a specific array (array A) is a subset of another array (array B). In other words, that all elements in array A are elements of array B.

Syntax

{%= subsetOf(array1, array2) %}

Example

The following operation defines people who have visited all of their favorite cities.

{%= subsetOf(person.favoriteCities,person.visitedCities) %}

Superset of superset

The supersetOf function is used to determine if a specific array (array A) is a superset of another array (array B). In other words, that array A contains all elements in array B.

Syntax

{%= supersetOf(array1, array2) %}

Example

The following operation defines people who have eaten sushi and pizza at least once.

{%= supersetOf(person.eatenFoods,["sushi", "pizza"]) %}

Iterate over an array each-loop

Use the Handlebars {{#each}} block helper to loop over an array and render content for each item in personalized content (email, SMS, push).

Syntax

{{#each arrayAttribute}}
  {{this}}
{{/each}}

{{#each profile.purchases.items}}
  - {{this.name}}: {{this.price}}€
{{/each}}

- Running shoes: 89€
- Water bottle: 15€
- Gym bag: 45€

{{#each profile.preferences.languages}}
  {{@index}}: {{this}}
{{/each}}

0: English
1: French
2: Spanish

{{#each profile.orders as |order|}}
  {%#if order.status = "pending"%}
  Your order {{order.id}} is still pending.
  {%/if%}
{{/each}}