How to return values after deleting relationship in neo4j

0
votes

How can I return the values of nodes and relationships after deleting a relationship

Cypher:

MATCH (p:Person)-[t:LIKED]->(a:Post) WHERE p.identity='kOo08cpMoYPWwnwB4XMZ3CbTRcO2' AND a.uuid='b60f773d-6d85-48bc-9900-8037c4b2c0b2' DELETE t WITH p,a MATCH (a)<-[l:LIKED]-() RETURN count(l) AS likes, exists((p)-[:LIKED]->(a)) AS liked, a.uuid AS uuid

the above query always returns [] , p and a nodes do exist.

1
neo4jcypher

1 Answers

1
votes

Looks like the second MATCH doesn't find any matches. Try to use the OPTIONAL MATCH statement:

MATCH (p:Person)-[t:LIKED]->(a:Post)
WHERE p.identity='kOo08cpMoYPWwnwB4XMZ3CbTRcO2' AND a.uuid='b60f773d-6d85-48bc-9900-8037c4b2c0b2'
DELETE t
WITH p,a
OPTIONAL MATCH (a)<-[l:LIKED]-()
RETURN count(l) AS likes, exists((p)-[:LIKED]->(a)) AS liked, a.uuid AS uuid