Sorry, to ask this question for the 100th time, but none of the previous posts was similar to my problem: I just want to get back TRUE or FALSE if a node with a certain label and a certain value of a property exists. (u:User {user_id: 1} => TRUE / FALSE All other posts where about MERGE and so on,…

If you add IS NOT null then you will get a true when property has the value /false when the property doesn't have the value. I hadn't thought of using OPTIONAL. Clever! Also you don't need exists(); you can just test n for null OPTIONAL MATCH (n:User{user_id:1}) RETURN n IS NOT NULL AS Predicate…

Check if node exists and use the result as a condition

Neo4j Graph Platform Cypher

clem (Clem) January 15, 2021, 8:23am 14

I added a suggestion to the documentation for OPTIONAL MATCH.

This is a great example!

I've learned a lot! Thanks for showing us OPTIONAL MATCH. I hadn't quite appreciated what it could do.

Check if node exists - proposal for a new APOC-function

Topic		Replies	Views
Check if node exists - proposal for a new APOC-function Procedures & APOC	10	1379	September 28, 2021
Predicate function understanding : exists() Cypher	3	744	February 12, 2020
Checking if a node exists Cypher	8	11910	December 5, 2018
Understanding non-existent properties and working with nulls Cypher cypher , knowledge-base	0	1080	August 23, 2018
Match relationships if a certain parameter exists Newbie Questions cypher , operations	2	377	September 17, 2020

Check if node exists and use the result as a condition

Related topics