Issue in Cypher query using if if and merge

Question

In given cypher query it showing error. Please let me know what is wrong in below Cypher query:

MATCH (pcp:PCP)-[]->(mt:MONEYTRANSFER{MTCN:'1618087665684829'}) return 
CASE WHEN  EXISTS( (pcp)-[:SENT_BY]-(mt{MTCN:'1618087665684829'}) ) 
THEN null ELSE MERGE (pcp:PCP)-[]->(mt:MONEYTRANSFER{MTCN:'1618087665684829'})
END

techie95 · Accepted Answer · 2017-10-24T10:22:09.887

0

try going through this question on stackoverflow. It gives the example of using CASES with MERGE

there's a work around for your query:

MATCH (pcp:PCP)-[r]->(mt:MONEYTRANSFER{MTCN:'1618087665684829'})
WITH pcp,r,mt, CASE WHEN (type(r) = 'SENT_BY') THEN [] ELSE ['create'] 
END as array1
FOREACH (el1 in array1 | CREATE (pcp)-[:SENT_BY]->(mt))
return pcp,mt,r

Edit: You cannot create a realtionship without specifying the label/type for it.

Hope this helps!

edited Oct 24 '17 at 10:22

answered Oct 24 '17 at 09:22

techie95

515
3
16

it should be comment – Govind Singh Oct 24 '17 at 09:53
@GovindSingh i was editing my answer. And as you can see i don't have the commenting privilege yet – techie95 Oct 24 '17 at 09:56

Issue in Cypher query using if if and merge

1 Answers1