Help on querying

[jomarca11]

Hi All

How can I query this? with subqueries?

I'm trying this

MATCH (o:Order)-[cont:CONTAINS]->(p:Product)-[r:PART_OF]->(c:Category)
where EXISTS {
(MATCH (:Supplier)-[:SUPPLIES]->(p))}
RETURN p.productName,cont.unitPrice;

But I get an error.

Kind Regards

[Cobra]

Hello @jomarca11

This should be enough normally:

MATCH (o:Order)-[cont:CONTAINS]->(p:Product)-[r:PART_OF]->(c:Category)
WHERE EXISTS((:Supplier)-[:SUPPLIES]->(p))
RETURN p.productName, cont.unitPrice;

Regards,
Cobra

[jomarca11]

Hi.
It should be right if I did not need to check a property from Supplier. That's why I tried with the MATCH clause
Regards

[giuseppe_villan · Accepted solution]

@jomarca11

Maybe this query should be fine for your case?

MATCH (o:Order)-[cont:CONTAINS]->(p:Product)-[r:PART_OF]->(c:Category), 
      (supplier:Supplier)-[:SUPPLIES]->(p)
// optional WHERE part
RETURN p.productName, p.unitPrice

Neo4j Graph Database Platform

Filtering Query Results - Developer Guides

Building on the Cypher Basics I and II guides, this guide continues with additional concepts of Cypher for filtering and query criteria. Upon finishing this guide, you should be able to filter results on properties and patterns for ranges and other...