Collection Templates
Collection templates perform lookup and aggregate functions over a collection. They can filter out specific collection members to operate over.
| Template name | Template format | Return type |
|---|---|---|
| lookup | lookup <expression> from<collection> where <filter>otherwise use <default> | type of evaluatedexpression |
| member number | member number <index> in<collection> | entity reference |
| the average of | the average of <numericexpression> in <collection> | integer or decimal |
| the first matching memberfrom | the first matching memberfrom <collection> where<filter expression> | integer or decimal |
| the first member in | the first member in<collection> | entity reference |
| the last member in | the last member in<collection> | entity reference |
| the number of | the number of <collection> | integer |
| any members exist in | any members exist in<collection> filtered by<filter expression> | Boolean |
| no members exist in | no members exist in<collection> filtered by<filter expression> | Boolean |
| the total of | the total of <numericexpression> in <collection> | integer or decimal |
| the minimum of | the minimum of <numericexpression> in <collection> | integer or decimal |
| the maximum of | the maximum of <numericexpression> in <collection> | integer or decimal |
| get first value | the value of <field> on thefirst member in <collection>otherwise use <default> | field value |
| get first value | the value of <field> on thelast member in <collection>otherwise use <default> | field value |
| the value of a member atan index | the value of <field> onmember number <integer>from <collection> otherwiseuse <default> | field value |