Why is a relationship not in the filter showing up?

joseph.roemer · May 4, 2020, 1:41pm

Why am I getting relationships beyond what I have in this Cypher statement?

Match(h:HCA{hcaAzId:"122730699"})<-[rel:ATTENDING]-(p:Practitioner)
Return h,p limit 15

I was expecting to only see ATTENDING relationships connected to the practitioners but I am also getting WORKS_WITH relationships.

stefan.armbruster · May 4, 2020, 2:05pm

By default "connect result nodes" is enabled in the browser, see screenshot.

If you disable this and run the query again, you only get those rels you've been returning.

Topic		Replies	Views
MATCH command displaying other relationships which is not part of the query Cypher cypher	2	160	January 11, 2024
Browser displaying all relationships between two nodes, even when filtered out Cypher	4	381	March 8, 2022
Unable to obtain the relationship based on the query Cypher cypher , knowledge-base	5	899	February 7, 2019
Query not returning any results Cypher	2	1036	May 10, 2019
Browser displaying all relationships between two nodes, even when filtered out Neo4j Graph Platform migrated , cypher-tagged	1	147	January 4, 2023