WHERE p.accountGUID = 'xxxxxxxxxx' AND NOT c.id IN ['76','1330', '65','1402', '1152','64','59']
Products are being returned from the above query that DO have relationships with categories from ...
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'