Please format code + Cypher statements with the code
</> icon, it's much easier to read.
I am trying to see how to run a MATCH query where I can see all paths from a certain Node with a specific property key to all Nodes with another specific property type but with out going past the first instance of the second node.
MATCH p=(c:Customer)-[*..5]-(e:Equip) WHERE c.CID STARTS WITH "CID12345" AND e.EquipCat CONTAINS "ROUTER" RETURN p
I want to do this search for the CID property of the Customer nodes and get the 2 paths to the first Equip node down each path that has the property Router. This path could be 2 relationships away or it could be 8. But, if both paths are only 2 away then [*..8] will go past the first Equip:Router node and find many others.. is there a relationship rule or some other method I can use to make sure I ONLY get to each of the FIRST Nodes with the property Router?