AND
Usage
Use this function to return a boolean AND expression between operands
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | 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
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
=AND(#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 and, meanwhile, if the cell values of the field Discount in the StorageExample are true
Result
true or false
Example 2
Formula
=AND(
=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, and, meanwhile, if the cell values of the field Status in the StorageExample are not equal to 1 and, meanwhile, if the cell values of the field Status in the StorageExample are equal to 2
Result
true or false