and()

This function checks if all values received are `true`. If they are, the function returns true. Otherwise, the function returns false.

Acceptable parameter types

• `INT`: `INT` type parameters must be 1 or 0. 1 means true and 0 means false.

• `BOOL`

• True: `TRUE`, `True`, `true`, 1

• False: `FALSE`, `False`, `false`, 0

Return value

• Returns 1 if all input values are 1. Returns 0 if one input value is 0.

• Returns boolean `TRUE` if all input values are `TRUE`, `True`, or `true`. Returns boolean `FALSE` if one input value is `FALSE`, `False`, or `false`.

Example

If we have the following data in a CSV file of the different pass/fail results of tests taken by students. To give a student vertex a result attribute of value `true`, all of their test results must be `true`. Otherwise, the attribute is set to false.

name result

Tommy

true

Tommy

true

Tommy

false

Amy

true

Amy

true

Amy

true

We can use the `and()` reduce function to load the boolean attribute:

``````LOAD f TO VERTEX Person
VALUES ($"name", REDUCE(and($"result"))``````

After loading, Tommy has a `result` of false and Amy has a `result` of true.