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	1310	September 28, 2021
Checking if a node exists Cypher	8	11814	December 5, 2018
How can I "not return" a "NULL" node in an apoc.case procedure when the condition is not met? Neo4j Graph Platform migrated	10	112	October 19, 2022
Apoc.do.when not creating nodes when is NULL check is true Neo4j Graph Platform migrated	1	150	January 12, 2023
How do I choose to create a node based on whether it exists in the database? Cypher	2	295	October 5, 2020

Check if node exists and use the result as a condition

Related topics