How can I display a list of couples

I am working on a query which has to display a list which contains nodes which worked together and count the number of their appearance , I wrote this query but I am getting a list of nodes which are working with the same Contract :


Without the query, a description of your model (for example a screenshot of your graph from the browser), and the result you want, it will hard to help you.

Can you update your question with those information ?


I hope this picture made it much better to get what I mean 46_1

It's better but still not enought.
What do you mean by :

And can you share the query you have done so far ?

1 Like

in my example , I mean that I want to display a list in which there are each two "Att" or more which worked with the same Contract and in the other row the number of times that those "Att" worked together . Here is my query :

MATCH (contrat:Contrat)-[r:ASSIGNED]->(at:Attrib)
WITH DISTINCT (contrat.cpv) AS a,
collect  (at.label) as b,
count (contrat) as c 
ORDER by c desc


Try this query:

MATCH p = (contrat:Contrat)-[r:ASSIGNED]->(at:Attrib)
WITH at, count(p) as Cnt
RETURN Cnt, COLLECT(at.label) as Attrib ORDER BY Cnt desc;

This should show the 'Result' in your picture. From your picture I recreated the database and tested the above query .

Hope this will help you.

1 Like

Thanks man it works :)