To repeat a section of a document, for example rows, title, or pages, use a "repetition example" with the reserved key word i and i+1.

Repeat nested arrays are managed at unlimited depth. The following example shows a repetition of a whole document.

Data

[
  {
    brand: "Toyota",
    models: [{ size: "Prius 2" }, { size: "Prius 3" }]
  },
  {
    brand: "Tesla",
    models: [{ size: "S" }, { size: "X" }]
  }
];

To iterate through arrays, use attributes of objects instead of the reserved iterator i . It can be used to sort data directly in the template.

In the following example, all cars are sorted by "power" in ascendant order (descendant order is not possible for the moment).

Data

{
  "cars" : [
    { "brand" : "Lumeneo" , "power" : 3 },
    { "brand" : "Tesla"   , "power" : 1 },
    { "brand" : "Toyota"  , "power" : 2 }
  ]
}

The following example shows how to travel an array of cars.

Data

{
  "cars" : [
    {"brand" : "Lumeneo"},
    {"brand" : "Tesla"  },
    {"brand" : "Toyota" }
  ]
}

The bi-directional loop performs iterations in 2 directions, creating additional columns and rows.

Data

[
  {
    brand: "Toyota",
    models: [{ name: "Prius 2" }, { name: "Prius 3" }]
  },
  {
    brand: "Tesla",
    models: [{ name: "S" }, { name: "X" }]
  },
  {
    brand: "Lumeneo",
    models: [{ name: "Smera" }, { name: "Néoma" }]
  }
];

To select distinct rows according to the attribute's value, use a custom iterator.

Data

Use conditional operators to filter arrays: > , < , >= , <= , =, !=.

Filters example with numbers

Filters should be the same on the ith+1 marker and all other markers if you want to keep only matching rows. Use an to simplify report maintenance.

Data

Filter example with strings

Filter with strings as shown in the example below.

Data

Filter with the iterator index

Filter the loop index as shown in the example below.

Data

In the , only distinct rows are kept.

To keep all rows and sort them by type in ascendant order, add the reserved iterator i. Separate multiple iterators with a comma ,.

Data

Access the iterator value when a list is printed into a document.

Example

In {d[i].cars[i].other.wheels[i].tire.subObject:add(.i):add(..i):add(...i)}

The number of dots equals the number of previous i:

• .i matches the index value of wheels[i]

• ..i matches the index value of cars[i]

• ...i matches the index value of d[i]

Iterate over objects if you need keys or values:

• use .att to print the attribute

• use .val to print the value

Data

  {
    myObject : {
      paul : '10',
      jack : '20',
      bob  : '30'
    }
  }