FIELDCONTAINS
Usage
Use this function to filter MULTISELECTION fields
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | VALUES LIST | .VALUE |
Syntax
1 | |
Arguments
#Storage.Field
Storage column field where to filter
Values_List
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned values list
Filter
filter specialization and can be (between quotation marks " ") ALL, NONE, ATLEAST and NATLEAST. If not specified, the default value is ALL
Parameter (only for Filter ATLEAST and NATLEAST)
rapresent the number of matching filters. If not specified the value is calculated as the count of filter values
Return Value
List
Examples
Example
Formula
=FIELDCONTAINS(#StorageExample.Column; =LIST(1; 2); "ALL")
Description
...
Result
...