Learn more about the collection functions EXISTS, EACH, ALL, COLLECT FROM WHERE, COLLECT FROM NAMED WHERE, COLLECT, UNPACK, LIST, SIZE, UNIQUE, SUBSET OF, UNION, INTERSECTION, DIFFERENCE, SYMMETRIC_DIFFERENCE.
Overview
| Function | Description |
|---|
EXISTS | Determines whether an instance of a specified entity exists, optionally meeting certain criteria. |
EACH | Determines whether all instances of a specified entity meet a certain criteria. |
ALL | Creates a collection of all instances of a specified entity. |
COLLECT FROM [WHERE] | Creates a collection of entity or attribute instances (meeting certain criteria). |
COLLECT FROM NAMED [WHERE] | Version of COLLECT FROM [WHERE] for complex nested selections with an alias. |
UNPACK | Extracts the value from a single valued collection or list. Is the inverse of the LIST function. |
LIST | Creates a list based on a value. Is the inverse of the UNPACK function. |
SIZE | Determines the size of a collection. |
UNIQUE | Filters duplicate items from a collection resulting from a subexpression in a larger expression. |
SUBSET OF | Returns TRUE if the items in a collection are all present in another collection. |
UNION | Adds two collections of the same base type to a new collection. |
INTERSECTION | Determines the intersection of two collections. |
DIFFERENCE | Determines the difference between 2 collections. Returns a collection containing all the items from collection1 that are not present in collection2. |
SYMMETRIC_DIFFERENCE | Determines the symmetric difference between two collections. Returns a collection with the elements of the provided collections which are in either one of the collections, but not in both. |
A note on collections and duplicates.
| Include Page |
|---|
| Collection function EXISTS |
|---|
| Collection function EXISTS |
|---|
|
| Include Page |
|---|
| Collection function EACH |
|---|
| Collection function EACH |
|---|
|
| Include Page |
|---|
| Collection function ALL |
|---|
| Collection function ALL |
|---|
|
| Include Page |
|---|
| Collection function COLLECT FROM WHERE |
|---|
| Collection function COLLECT FROM WHERE |
|---|
|
| Include Page |
|---|
| Collection function COLLECT FROM NAMED WHERE |
|---|
| Collection function COLLECT FROM NAMED WHERE |
|---|
|
| Include Page |
|---|
| Collection function UNPACK |
|---|
| Collection function UNPACK |
|---|
|
| Include Page |
|---|
| Collection function LIST |
|---|
| Collection function LIST |
|---|
|
| Include Page |
|---|
| Collection function SIZE |
|---|
| Collection function SIZE |
|---|
|
| Include Page |
|---|
| Collection function UNIQUE |
|---|
| Collection function UNIQUE |
|---|
|
| Include Page |
|---|
| Collection function SUBSET OF |
|---|
| Collection function SUBSET OF |
|---|
|
| Include Page |
|---|
| Collection function UNION |
|---|
| Collection function UNION |
|---|
|
| Include Page |
|---|
| Collection function INTERSECTION |
|---|
| Collection function INTERSECTION |
|---|
|
| Include Page |
|---|
| Collection function DIFFERENCE |
|---|
| Collection function DIFFERENCE |
|---|
|
| Include Page |
|---|
| Collection function SYMMETRIC_DIFFERENCE |
|---|
| Collection function SYMMETRIC_DIFFERENCE |
|---|
|
| Include Page |
|---|
| A note on collections and duplicates |
|---|
| A note on collections and duplicates |
|---|
|