HI
I use the follwowing query
MATCH
((node_left: org)-[relationship_leftnode_currentstatus: current_status]->(node_currentstatus)),
((node_left)-[relationship_leftnode_hasmail: has_mail]->(node_mail))
CALL {
WITH node_left
MATCH ((node_left)-[relationship_leftnode_hasmail: has_mail]->(node_mail))
WITH distinct node_mail LIMIT 10
RETURN collect(node_mail.name) AS MailList
}
RETURN
node_left.name AS LeftNode ,
MailList,
node_currentstatus.name AS CurrentStatus;
Unfortunately I get as result 2 times exact the seleceted row back ... Can anyone tell me how to use DISTINCT correctly?
โ"LeftNode" โ"MailList" โ"CurrentStatus"โ
โ"_AdminOrg"โ["admingroup@local","rootmessages@local"]โ"active - Org" โ
โ"_AdminOrg"โ["admingroup@local","rootmessages@local"]โ"active - Org" โ
Thanks rob