CODEWITHSUNDEEP
neo4jcypher
alexanoid
alexanoid

Reputation: 25770

Neo4j Cypher Match all

There is the following schema:

Person-[:HAS]->(:Skill)<-[:REQUIRES]-(:Job)

Job requires some number of Skills. How to properly with Cypher MATCH Person which has ALL of the Skills required by some certain Job?

Upvotes: 1

Views: 129

Answers (1)

Charchit Kapoor
Charchit Kapoor

Reputation: 9284

Try this, here we collect skills of the job and the person skills in different collections and then we check if all the skills for the job, are present in the persons skill collection:

MATCH (j:Job)-[:REQUIRES]->(s:Skill)
WITH j, collect(DISTINCT s) AS skillsRequiredForTheJob
MATCH (p:Person)-[:HAS]->(s:Skill)
WITH j, p, skillsRequiredForTheJob, collect(DISTINCT s) AS personSkills
WHERE ALL(skill IN skillsRequiredForTheJob WHERE skill IN personSkills)
RETURN p

Upvotes: 2

Related Questions