Hi, I have this model:
LESSON - Properies: Title
TEACHER - Properties: Name
TEACHER->LESSON relationship named SPEAKER - Properties: Years (example: [2011,2012,2013])
Situation: The same LESSON can have different TEACHER in different Years.
Preformatted textMATCH (P:TEACHER)-[REL:SPEAKER]->(L:LESSON) WHERE 2011 IN REL.Years RETURN P,L
The problem is the difference from Graph and Text table results.
- In the graph I see the SPEAKER relationship for TEACHER and LESSON even if the teacher he didn't give a lesson in 2011, but in other years. It's Wrong.
- In text table I see the TEACHER and LESSON only for 2011. It's OK.
Do you have any suggestions?
- Neo4j version 4.0.4