Neo4j

poornima · 08-05-2021

Hello Neo4jers, Back again! The Cypher manual says - WITH is also used to separate reading from updating of the graph. Every part of a query must be either read-only or write-only. When going from a writing part to a reading part, the switch must be...

poornima · 08-03-2021

Hello fellow Neo4jers/ians! Going through the lessons under Querying with Cypher and a question - Related note from the Cypher Manual page - In the case of multiple MATCH / OPTIONAL MATCH clauses, the predicate in WHERE is always a part of the patt...

poornima · 09-18-2021

Hello there, I understand you want to do - if ((x.a > 0 AND y.a = 0) OR (x.a = 0 AND y.a > 0)) then r.a = 0 else r.a = (abs(x.a - y.a) * 1.5) if ((x.b > 0 AND y.b = 0) OR (x.b = 0 AND y.b > 0)) then r.b = 0 else r.b = (abs(x.b - y.b) * 1.0) Is t...

poornima · 09-12-2021

sebastien-ext: I quite don't understand this : Blockquote You see just by changing the order of creation of the nodes and particularly the relationships, I was able to get your good query to Fail!!!! Hi, So what I meant was without changing...

poornima · 09-10-2021

Hi, size() takes in an aggregate data structure such as a list of values as input whereas the use of an aggregating function like count() requires a grouping of rows i.e. aggregation by some criteria is required to produce an output. From the perspec...

poornima · 09-09-2021

This is the query we should use - CALL { MATCH (n:Student)-[r:WORKS_WITH]->(m:Tutor) RETURN n,m ORDER BY n.name,m.name } WITH n,collect(m.name) as tutors RETURN collect(n.name) as studs, tutors

poornima · 09-09-2021

@ameyasoft hold on, I suspect this query will need a sort somewhere in between to be absolutely foolproof. Also, Still doesn't give OP's expected result.

Neo4j

User Statistics

User Activity

Using the WITH clause to separate READ and WRITE queries

How does this work - Multiple MATCH/OPTIONAL MATCH statements with WHERE

Re: How to mimic conditions while running a query to create relationships

Re: I do not understand why I have this result

Re: Aggregation

Re: I do not understand why I have this result

Re: I do not understand why I have this result