Neo4j

wplumot · ‎01-26-2021

I am a bit new here ...but I have a node with one or more relation of the same type:
(RR)-[:has_bol]->(BB)
RR can have many BB

So RR can have many relations pointing to BB with property 'Code'.
Say we have:
RR1 has_bol with BB.Code: 'ab'
RR2 has_bol with BB.Code: 'abc'
RR2 has_bol with BB.Code: 'xc'
RR3 has_bol with BB.Code: 'xca'
RR3 has_bol with BB.Code: 'xc6'
RR3 has_bol with BB.Code: 'xcga'
..... 1000things further
RRx has_bol with BB.Code: 'anything'

I need a query with no performance issue that gets all the RR nodes with BB nodes where BB contains 'xc'.

If RR has 3 relations to BB with one match on BB, the query returns RR with 3 BB nodes, not one BB.

In our example above it will return RR2 with the two nodes of BB (abc, xx) and also RR3 with 3 nodes of BB ('xca', 'xc6', 'xcga')

How can one make that one work.
You can compare it with the stuff command in SQL, which have performance issues with big data.

ameyasoft · ‎01-26-2021

Try this:
To return BB (abc, xx) :
MATCH (RR)-[:has_bol]->(BB)
WHERE BB.Code = 'xx' or BB.Code ENDS WITH 'c'
RETURN RR, BB

To return BB ('xca', 'xc6', 'xcga')
MATCH (RR)-[:has_bol]->(BB)
WHERE BB.Code BEGINS WITH 'xc'
RETURN RR, BB

wplumot · ‎01-27-2021

Thank you, I thought I was doing things wrong but it seems that the simple solutions are just fine.
Start to love Neo4j

clem · ‎01-28-2021

You might want to look at this training, especially the part about refactoring and using multiple Labels on a Node.

See:

Neo4j

Best cypher query for having a match on multiple relations