Neo4j

wgevaert · 07-18-2022

I am building an application that should accept quite general input and be able to generate quite elaborate Cypher queries. I get stuck on the following:Suppose we have the following example database: CREATE (John {name:'John Doe', age:30})-[:HAS_AUT...

wgevaert · 07-18-2022

This does seem to be similar to what I typed, but you used parentheses "()" instead of curly brackets "{}". Is there any reason why you prefer parentheses over curly brackets in the exists clause?

wgevaert · 07-18-2022

The answer is obvious after a little bit of pondering.Instead of this:WHERE n.age > 50 OR EXISTS { MATCH (n)-[:HAS_AUTOGRAPH]->()-[:IS_NICKNAME_OF*0..1]->({name:'Joseph Quinn'}) MATCH (n)-[:LIVES_NEARBY]->()-[:IS_NICKNAME_OF*0..1]->({name:'Jose...

wgevaert · 07-18-2022

I think the following query might do something you want: MATCH (User1)-[:hasItem]->()<-[:hasItem]-(OtherUser)-[:hasItem]->(ItemToRecommend) WHERE NOT (User1)-[:hasItem]->(ItemToRecommend) WITH id(ItemToRecommend) AS RecommendedId, count(*) AS num...

Neo4j

User Statistics

User Activity

Prevent relationship isomorphism in exists clause

Re: Prevent relationship isomorphism in exists clause

Re: Prevent relationship isomorphism in exists clause

Re: Simple Recommendation