Skip to content

OR

Usage

Use this function to return a boolean OR expression between operands

Category Function Type Where to use Argument statement
FUNCTION SERVER ROW LOGICAL .VALUE

Syntax

1
=OR(Condition_1; Condition_n)

Arguments

Condition_1
any Boolean conditional expression or function on storage field values (#Storage_Name.Field_Name.VALUE or .OLDVALUE)

Condition_n
any Boolean conditional expression or function on storage field values (#Storage_Name.Field_Name.VALUE or .OLDVALUE)

Note

EQ, NEQ, GT, GTE, LT, LTE, ISNULL or ISNOTNULL functions must be used in the conditional arguments to check the value returned by a SERVER FUNCTION

Return Value

Boolean (true or false)

Examples

Example 1

Formula
=OR(#StorageExample.Price.VALUE > 100; #StorageExample.Discont.VALUE == true)

Description
Check if the cell values of the field Price in the StorageExample are greather than 100 or if the cell values of the field Discount in the StorageExample are true

Result
true or false

Example 2

Formula
=OR( =CONTAINSLIST(
=LIST($CURRENTUSER.GROUPNAMES);
=LIST("Group 1"; "Group 2")
);
=NEQ(#StorageExample.Status.VALUE; 1);
=EQ(#StorageExample.Status.VALUE; 2);
)

Description
Check if the value list Group 1, Group 2 is contained in the Groups list of the current User (variable), so if the User is in the Group 1 and Group 2 or if the cell values of the field Status in the StorageExample are not equal to 1 or if the cell values of the field Status in the StorageExample are equal to 2

Result
true or false