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
1条答案
按热度按时间iovurdzv1#
试一试,我们在这里收集不同集合中的工作技能和人员技能,然后检查人员技能集合中是否存在该工作的所有技能: