Search list with mutual count (2nd try)

by

As I said in my comment, trying to query for connected and disconnected nodes at the same time doesn’t seem to be a good idea.

If you want only connected nodes, try the following query :

START me=node:node_auto_index(UserName="manish") 
MATCH me-[:friends]-mf-[:friends]-other, me-[r?]-other 
WHERE other.UserName! =~ '(?i)dh.*' 
RETURN DISTINCT ID(other), r.ApprovalStatus AS status, count(mf) AS mutual, ID(me) 
ORDER BY mutual DESC , status ASC

Please note that I had to add another pattern in the match clause, because your approval status is between (me) and (other), and not between (me) and (mutual friend), which is what you were doing!

This will return the first 3 lines of your expected answer and ignores dhansukh.

More Related Contents:

  1. Why does neo4j warn: “This query builds a cartesian product between disconnected patterns”?
  2. Return node if relationship is not present
  3. Returning only simple paths in Neo4j Cypher query
  4. What does a comma in a Cypher query do?
  5. How to hide unwanted relationships between nodes in Neo4j
  6. Is there a way to show cypher execution plan?
  7. How can I express additional information (time, probability) about a relation in RDF?
  8. APOC is only partially installing its extension in neo4j (one procedure)
  9. Does Karate supports Neo4j Database?
  10. Cypher Neo4J – CASE Expression with MERGE
  11. Neo4j Spatial ‘WithinDistance’ Cypher query returns empty while REST call returns data
  12. Node identifiers in neo4j
  13. Gremlin remove all Vertex
  14. Extract subgraph in neo4j
  15. What are the use cases of Graph-based Databases (http://neo4j.org/)? [closed]
  16. How to increase Neo4j’s maximum file open limit (ulimit) in Ubuntu?
  17. Casting nodes of an unknown type

Leave a Comment