You can ask the queries like ‘give me the nodes that has either of given relationship using | (OR) operator’.
Let’s see it with an example.
Step 1: Open neo4j browser by hitting following url in browser.
http://localhost:7474/browser/
Step 2: Insert data by executing below query.
CREATE (p1:Person{name: "Rama Krishna", age: 32, city: "Bangalore", male: true, designation: "CEO"}), (p2:Person{name: "Murali", age: 32, city: "Hyderabad", male: true, designation: "Vice President"}), (p3:Person{name: "Gopi", age: 34, city: "Chennai", male: true, designation: "Vice President"}), (p4:Person{name: "Kiran", age: 28, city: "Bangalore", male: true, designation: "Director"}), (p5:Person{name: "Siva", age: 45, city: "Hyderabad", male: true, designation: "Director"}), (p6:Person{name: "Kiran", age: 36, city: "Hyderabad", male: true, designation: "Manager"}), (p7:Person{name: "Ritweek", age: 23, city: "Bangalore", male: true, designation: "Manager"}), (p8:Person{name: "Sudheer", age: 24, city: "Chennai", male: true, designation: "Manager"}), (p9:Person{name: "Naveen", age: 37, city: "Bangalore", male: true, designation: "Employee"}), (p10:Person{name: "Sailaja", age: 31, city: "Hyderabad", female: true, designation: "Employee"}), (p11:Person{name: "Harika", age: 36, city: "Bangalore", female: true, designation: "Employee"}), (p12:Person{name: "Brahmam", age: 41, city: "Bangalore", male: true, designation: "Employee"}), (office1:Location{name: "Pluto", city: "Bangalore"}), (office2:Location{name: "Mars", city: "Chennai"}) MERGE (p2)-[:REPORT_TO{from: 2014}]->(p1) MERGE (p3)-[:REPORT_TO{from: 2016}]->(p1) MERGE (p4)-[:REPORT_TO{from: 1997}]->(p2) MERGE (p5)-[:REPORT_TO{from: 1997}]->(p3) MERGE (p6)-[:REPORT_TO{from: 2001}]->(p4) MERGE (p7)-[:REPORT_TO{from: 2009}]->(p4) MERGE (p8)-[:REPORT_TO{from: 1998}]->(p5) MERGE (p9)-[:REPORT_TO{from: 2003}]->(p6) MERGE (p10)-[:REPORT_TO{from: 2004}]->(p6) MERGE (p11)-[:REPORT_TO{from: 2008}]->(p7) MERGE (p12)-[:REPORT_TO{from: 2019}]->(p8) MERGE (p2)-[:FRIEND_TO{from: 2014}]->(p1) MERGE (p10)-[:FRIEND_TO{from: 2014}]->(p8) MERGE (p7)-[:FRIEND_TO{from: 2014}]->(p9) MERGE (p3)-[:RELATIVE_TO{from: 2014}]->(p4) RETURN p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, office1, office2
Step 3: Execute below query to get all the nodes who are either in FRIEND_TO or RELATIVE_TO relationship.
MATCH (n1)-[rel:RELATIVE_TO | FRIEND_TO]->(n2) RETURN n1, n2, rel
Above statement matches the nodes if there is any relationship RELATIVE_TO or FRIEND_TO between nodes from n1 to n2.
Get the nodes who are either friend or relative to a person
MATCH (n1)-[rel:RELATIVE_TO | FRIEND_TO]->(n2) RETURN n1
Previous Next Home
No comments:
Post a Comment