The FOREACH clause is used to update data within a list, whether components of a path, or result of aggregation.

3.15.1. Introduction

Lists and paths are key concepts in Cypher. FOREACH can be used to update data, such as executing update commands on elements in a path, or on a list created by aggregation.

The variable context within the FOREACH parenthesis is separate from the one outside it. This means that if you CREATE a node variable within a FOREACH, you will not be able to use it outside of the foreach statement, unless you match to find it.

Within the FOREACH parentheses, you can do any of the updating commands — CREATE, CREATE UNIQUE, MERGE, DELETE, and FOREACH.

If you want to execute an additional MATCH for each element in a list then UNWIND (see Section 3.6, “UNWIND”) would be a more appropriate command.

Figure 3.14. Graph

3.15.2. Mark all nodes along a path

This query will set the property marked to true on all nodes along a path.


MATCH p =(begin)-[*]->(END )
WHERE begin.name = 'A' AND END .name = 'D'
FOREACH (n IN nodes(p)| SET n.marked = TRUE )

Nothing is returned from this query, but four properties are set.

Table 3.111. Result

0 rows Properties set: 4

(empty result)

Try this query live.  CREATE (a:Person {name: 'A'}), (b:Person {name: 'B'}), (c:Person {name: 'C'}), (d:Person {name: 'D'}), (a)-[:KNOWS]->(b), (b)-[:KNOWS]->(c), (c)-[:KNOWS]->(d) MATCH p = (begin)-[*]->(end) WHERE begin.name = 'A' AND end.name = 'D' FOREACH (n IN nodes(p) | SET n.marked = true)