Create relationship when NOT exist ELSE update (sounds like merge, but ..)

Neo4j Graph Platform Cypher
4

You don't need to use parenthesis for MERGE and ON CREATE or ON MATCH:

:param orgguid => 'fd21ccc6-0933-415b-97e3-d88129301b8a';
:param currentStatusguid => 'b10eb05e-5808-4335-aa7f-f717d47626ba';
:param futurecurrentstatus => 'ed6a6d0f-0d5b-456d-baca-5a0803a854ad';
MATCH (node1 {guid: $orgguid}), (node2 {guid: $futurecurrentstatus})
MERGE (node1)-[r:current_status {status: "active"}]->(node2)
ON CREATE SET r.guid = randomUUID()
ON MATCH SET r.timestamp_unix_changed = timestamp();
1 Like