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