Source: https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/variable-definition/agg/and_agg/
Documentation version: v5.3.2

# AndAgg

An AndAgg aggregator value variable (`AndAgg`) maintains the result of logical `AND` operation on all inputs of the boolean type.

## Declaration syntax

diagramsource

 and_agg_declaration  

````
and_agg_declaration ::=
    'NODE'? 'VALUE' aggregator_value_variable 'AndAgg' '=' value_expression

````

For information about the parameters in the declaration syntax, see [Parameters](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/variable-definition/agg/#parameters).

## Initial value

As indicated in the declaration syntax, an initial value is required during declaration.

## Input type and supported operations

The input type must be boolean.

Both [assignment and aggregation](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/set/) operations are supported: 

- Assignment operation (`=`): This operation resets the value of the aggregate value variable. For example, `SET @and_agg = true` clears the value held by the aggregate value variable `and_agg` and sets it to `true`. At this point, the result is `true`.
- Aggregation operation (`+=`): This operation performs the logical `AND` operation on the value of the aggregate value variable and the input value, and updates the aggregate value variable with the result. For example, if `and_agg` has a value of `true`, executing `SET @and_agg += false` changes the value to `false` (because `true AND false` is `false`).

## Return type

````
AndAgg -> BOOLEAN

````

The return type is always `BOOLEAN`.

## Examples

The following examples are based on the temporary graph `#movie_temporary_graph` created in [CREATE TEMPORARY GRAPH](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/ddl/graph-projection/create/).

### Global AndAgg aggregator value variables

````
'''
USE #movie_temporary_graph {
  VALUE global_and AndAgg = true

  // Aggregation: true AND true -> result remains true
  SET @global_and += true

  // Aggregation: true AND false -> result becomes false
  SET @global_and += false

  // Aggregation: false AND true -> result remains false 
  SET @global_and += true

  LOG_INFO("@global_and: ", @global_and)

  // Assignment: reset variable directly to true
  SET @global_and = true

  LOG_INFO("@global_and: ", @global_and)
}
'''

````

Return:

````
Log:
2025-08-21T09:54:50.956839 INFO  - @global_and: false
2025-08-21T09:54:50.957806 INFO  - @global_and: true

````

### Node-attached AndAgg aggregator value variables

````
'''
USE #movie_temporary_graph {
  NODE VALUE node_and AndAgg = true

  MATCH (a@User WHERE a.id in [3,4])-[]->(b@Movie)
  PER PATH {
    // For each user, perform logical AND with condition (b.id > 100)
    // The aggregator becomes false if any connected movie has id <= 100
    SET a.@node_and += (b.id > 100)
  }
  PER NODE (a) {
    LOG_INFO("a.id: ",a.id, " a.@node_and: ",a.@node_and)
  }
}
'''

````

Return:

````
Log:
2025-08-21T09:58:56.690844 INFO  - a.id: 4 a.@node_and: false
2025-08-21T09:58:56.690844 INFO  - a.id: 3 a.@node_and: true

````