I want to create a new node (
event nodes) among a set of nodes (
report nodes) according to the
indicator nodes (each report node has several indicator nodes related to it). I want to set the new
event nodes with the rules:
report nodesis only connected one
- if more than one
indicator nodeshas the same property "pattern", then they belong to the same event node
here are my query code :
OPTIONAL MATCH (indicator_1_1:indicator)<-[:REFERS_TO]-(report_1:report)-[:REFERS_TO]->(indicator_1_2:indicator), (indicator_2_1:indicator)<-[:REFERS_TO]-(report_2:report)-[:REFERS_TO]->(indicator_2_2:indicator) WHERE indicator_1_1.pattern=indicator_2_1.pattern and indicator_1_2.pattern=indicator_2_2.pattern MERGE (report_1)-[:related_to]->(event:EVENT)<-[:related_to]-(report_2)
But i want the three report nodes belong to one event node.
I want to know what changes should I make to my query ,or what next step should I take after getting the two event nodes.
What's more , I want to know wheter there is a more efficient query code than mine.