I have a situation here i hv created
MERGE (socketType)-[:SOCKET_OF_LEVEL]->(level)
MERGE (socketType)-[:SOCKET_OF_POWER]->(maxPowerKW)
Above A level can hv multiple socketTypes and each socketTypes can have a single or multiple maxPowerKW
Now I did something like following
CREATE (station)-[:HAS_OUTLET]->(outlet:Outlet {
uuid: apoc.create.uuid()
})-[:HAS_SOCKET]->(socketType)
Here a station can have multiple outlets but each outlet will hv a single socket type and a single maxPowerKW and a single Level
But as you can understand I could not achieve that, my match
MATCH (c:ChargingStation { uuid: "f9d3a8f2-b6d8-499d-88c2-5407ce854dae"})-[:HAS_OUTLET]->(o:Outlet)-[:HAS_SOCKET]->(s:SocketType)
MATCH (p:SocketMaxPower)<-[:SOCKET_OF_POWER]-(s)-[:SOCKET_OF_LEVEL]->(l:SocketLevel)
return c, o, s, p, l
always returns all associated powers and levels.... Can anyone help :(