Page History
...
Panel | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||
UNPACKUse this function to extract the value from a single valued collection or list. It is the inverse of the LIST function. Syntax
Return type
Examples Suppose the following data model.
UNPACK ( COLLECT Person.name FROM ALL Person WHERE ( Person.SequenceNumber = MAX ( COLLECT Person.SequenceNumber FROM ALL Person ) ) ) = “Jenny”
|
Panel | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||
LISTUse this function to create a list based on a value. It is the inverse of the UNPACK function. Syntax
Return type
Examples
Suppose the following data model.
|
Panel | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||
SIZEThis function determines the size of a collection. Syntax
Return type
Example Suppose you have a
Then:
|
...
Overview
Content Tools