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) … Read more
To do conditional write operations you need to use the FOREACH trick. Using CASE you either return a one element array or a empty one. FOREACH iterates over the CASE expression and therefore conditionally executes the action. If you want an ELSE part as well you need to have a another FOREACH using the inverse … Read more
You can still find the neo4j shell, where you can run the profile command. Either by connecting to the running server by starting bin/neo4j-shell Or by switching to the old web-ui in the “(i)” Info-menu on the left side and selecting the bottommost link “webadmin” -> http://localhost:7474/webadmin Profiling information will be added to browser later … Read more
In neo4j 3.2.1 this feature has been relocated to the bottom left corner, under the gear icon: “Connect result nodes” (checked by default, thus returning all relationships between nodes included in the result).
Since Cypher’s ASCII-art syntax can only let you specify one linear chain of connections in a row, the comma is there, at least in part, to allow you to specify things that might branch off. For example: MATCH (a)–>(b)<–(c), (b)–>(d) That represents three nodes which are all connected to b (two incoming relationships, and one … Read more
Specifying the uniqueness of paths is a planned feature of cypher. So right now we have to ascertain that no node is a duplicate in the path. There is an ALL predicate that must hold true for all elements of a collection (which a path is). And with filter you can extract the elements of … Read more
Update 01/10/2013: Came across this in the Neo4j 2.0 reference: Try not to use optional relationships. Above all, don’t use them like this: MATCH a-[r?:LOVES]->() WHERE r IS NULL where you just make sure that they don’t exist. Instead do this like so: MATCH a WHERE NOT (a)-[:LOVES]->() Using cypher for checking if relationship doesn’t … Read more
The browser is telling you that: It is handling your query by doing a comparison between every Gene instance and every Chromosome instance. If your DB has G genes and C chromosomes, then the complexity of the query is O(GC). For instance, if we are working with the human genome, there are 46 chromosomes and … Read more