How can I display a list of couples

cypher
grouping

(Mehdi Ajroud) #1

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 :


(Benoit Simard) #2

Hi,

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 ?

Thanks


(Mehdi Ajroud) #3

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


(Benoit Simard) #4

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

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


(Mehdi Ajroud) #5

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 
RETURN DISTINCT  (b),c,a
ORDER by c desc

(Ameyasoft) #6

Hi,

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.
-Kamal


(Mehdi Ajroud) #7

Thanks man it works :)