SQLIN
Usage
Use this function to check if a specified value matches any value in a subquery or a list
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | LOGICAL | .VALUE |
Syntax
1 |
|
Arguments
Value_To_Check
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Value_1
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Value_n
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
Note
SQLIN must be used only as conditional expression in SERVER STORAGE functions
Return Value
Boolean
Examples
Example_1
Formula
=SUM(
#StorageExample;
#StorageExample.InvoiceAmount;
=SQLIN(#StorageExample.InvoiceType; 1; 2)
)
Description Return the sum of column InvoiceAmount of StorageExample where InvoiceType of StorageExample is 1 or 2
Result Sum depending on the InvoiceType