SQLOR
Usage
Use this function to return a boolean OR expression between the passed parameters
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | LOGICAL | .VALUE |
Syntax
1 | |
Arguments
Condition_1
any SERVER function returns Boolean value or function on Storage field values (#Storage_Name.Field_Name.VALUE or .OLDVALUE)
Condition_n
any SERVER function returns Boolean value or function on Storage field values (#Storage_Name.Field_Name.VALUE or .OLDVALUE)
Note
SQLOR must be used only as conditional expression in SERVER STORAGE functions
Return Value
Boolean
Examples
Example 1
Formula
=LOOKUP(
#StorageExample_1;
#StorageExample_1.OfferNumber;
=SQLOR(
#StorageExample_1.Customer == #StorageExample_2.Customer.VALUE;
#StorageExample_1.Supplier == #StorageExample_2.Supplier.VALUE
)
)
Description We performed this formula in a calculated fiedl where we want to take from Storage StorageExample_1 the OffertNumber where the Customer of StorageExample_1 or Supplier of StorageExample_1 matches with Customer of StorageExample_2 or Supplier of StorageExample_2 (LOOKUP function)
Result OffertNumber or null