FILTER

Usage

Use this function to filter a LOOKUP field from a dipendent field

Category	Function	Type	Where to use	Argument statement
FUNCTION	CLIENT	VALUES LIST	See Note below	.METADATA

Syntax

=FILTER(#Storage.Field_1; #Storage.Field_2.METADATA)

Arguments

#Storage.Field_1
Lookup source storage field to be filtered on its items to generate the lookup list

#Storage.Field_2.METADATA
Storage column field used as key in dependent filtering

Note

This formula is used only in the Formula section of the LOOKUP configuration:

Return Value

List

Examples

Example

Formula
=FILTER(#StorageExample_1.Column_1; #StorageExample_2.Column_2.METADATA)

Description
Filter values of the field Column_1 of the lookup Storage StorageExample_1 with values of the field Column_2 of the Storage StorageExample_2

Result
Filtered values of the field that contains the lookup