Page History
...
Panel | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
EACHThis function determines whether all instances of a specified entity meet a certain criteria Syntax
Return type
Examples Suppose the following data model.
|
Panel | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
ALLUse this function to create a collection of all instances of a specified entity. Syntax
Return type
Examples Suppose the following data model. The
|
...
Panel | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
SUBSET OFThis function returns Syntax
Return type
Diagram Examples
|
Panel | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||
UNIONAdds two collections of the same base type to a new collection. Syntax
Return type
Diagram Examples Suppose you have a
|
Panel | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||
INTERSECTIONThis function determines the intersection of two collections. It returns a collection containing the items that are present in both specified collections. Syntax
Return type
Diagram Examples Suppose the following model. Entity
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
DIFFERENCEThis function returns a collection containing all the items from collection1 that are not present in collection 2. Syntax
Return type
Diagram Examples
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SYMMETRIC DIFFERENCEThis function determines the symmetric difference between two collections. It returns a collection with the elements of the provided collections which are in either one of the collections, but not in both. Syntax
Return type
Diagram Examples
|
Panel | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
A note on collections and duplicatesAn expression resulting in a collection does not contain duplicates. Please be aware however, that intermediary results of a This is best illustrated with the following examples.
Now an example with the UNPACK function. We leave out the first instance from the previous example.
|