Neo4j

jake1 · 08-06-2020

MATCH (p)-[:HAS_CATEGORY]->(c:ProductCategory) WHERE p.accountGUID = 'xxxxxxxxxx' AND NOT c.id IN ['76','1330', '65','1402', '1152','64','59'] return p Products are being returned from the above query that DO have relationships with categories from ...

jake1 · 07-28-2020

Hi all, here is the cypher query in question MATCH (o:Order)-[:CONTAINS_PRODUCT]->(x:Product)-[:HAS_CATEGORY]->(xcat:ProductCategory), (x:Product)-[:HAS_VARIANT]->(v:ProductVariant) WHERE x.id IN ['8186'] AND x.accountGUID = 'xxxxxxxxx' WITH min(v.pr...

Neo4j

User Statistics

User Activity

Is filtering with a WHERE NOT IN on a collection like this possible? Not seeing expected results even on simple queries

Query returning results with nodes that should have been filtered out in WHERE NOT IN {collection}