LOOKUPLIST
Usage
Use this function to return the a list of values of a matching property of a collection given a confrontation parameter
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | COMPARISON | .VALUE |
Syntax:
1 |
|
Arguments
#Storage
the source storage entity
#Storage.Return_Field
the column field whose values will be returned
#Storage.Condition_Field
the column name used to check the condition and return the field value
Condition_Value
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Return Value
List of values
Examples
Example 1
Formula
=LOOKUPLIST(#StorageExample; #StorageExample.Column_1; #StorageExample.Column_2 == 1)
Description
Take from Storage StorageExample the values of the Column_1 where the Column_2 of the Storage StorageExample matches with value 1
Result
List of values of the Column_1
Example 2
Formula
=LOOKUPLIST(#StorageExample; #StorageExample.Role; #StorageExample.Email == $CURRENTUSER.EMAIL)
Description
Take from Storage StorageExample the values of the column Role where the column Email of the Storage StorageExample matches with current User email
Result
Roles of the current User
Example 3
Formula
=LOOKUPLIST(
#StorageExample_1;
#StorageExample_1.Role;
#StorageExample_1.Email == #StorageExample_2.Email.VALUE
)
Description
Take from Storage StorageExample_1 the values of the column Role where the column Email of the Storage StorageExample_1 matches with the value of the column Email of the Storage StorageExample_2
Result
Roles linked to the Email of the StorageExample_2