What is wrong in this quey

Neo4j Graph Platform Cypher
, , ,
1

Hi
With this query I'm getting this error
MATCH (o:Order)-[cont:CONTAINS]->(p:Product)-[r:PART_OF]->(c:Category)
where EXISTS {
(MATCH (:Supplier)-[:SUPPLIES]->(p))}
RETURN p.productName,cont.unitPrice;

Neo.ClientError.Statement.SyntaxError
Neo.ClientError.Statement.SyntaxError: Invalid input ':': expected whitespace, DISTINCT, an expression or ')' (line 3, column 9 (offset: 94))
" MATCH (:Supplier)-[:SUPPLIES]->(p))"
^

Any help?

Regards

2

It's the extra set of ( ) inside of the EXISTS that is causing an error. The open parenthesis (introduces an expression but MATCH is a clause.

Instead, try:

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

Best,
ABK

3

Still getting the error

image
image1439×382 21.6 KB

4

Which version of Neo4j database do you use?

5

Neo4j Browser version: 3.2.20

Neo4j Server version: 3.5.8 (community)

6

This version of Neo4j doesn't support this syntax, you will have tu upgrade to the 4.0 at least to use it.

7

Hi.

I think what happens with CALL error is the same for this version.

image
image1459×398 21.6 KB

8

Yes, subqueries have appeared with 4.0.

9

Many thanks for your help!