Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
05-25-2020 02:08 PM
match (n:Product)-[r:instanceOf]-(m:Category) where exists(n.ID`) and exists(m.ID) return distinct count(n)
This returns the number of relationships in which n and m occurs.
What I want is to find the unique number of n or m where n is instanceOf m and both n & m have the property 'ID'.
05-26-2020 02:23 AM
Try below
match (n:Product)-[r:instanceOf]-(m:Category) where exists(n.ID) and exists(m.ID) With count(distinct n) as N, count(distinct m) as M return N, M
All the sessions of the conference are now available online