Hi, I always struggle to query/model things like this effectively:
match (a:A)-[:REL1]->(b:B) where b.prop in range ( x, y ) and not ( (a)-[:REL2]->(c:C) where c.start < $val < c.end )
I know that construct/syntax isn't valid, but is there a way to do this? "Find As which are connected to specific Bs but which are not connected to Cs which fit a particular predicate". How do you do the "where" clause of the "without-this-path" section?
Alternatively, is there a way to model the nodes and relationships differently so this doesn't come up?