Variable Not defined

Neo4j Graph Platform Cypher
1

This is my query

MATCH (n:SampleLabel)-[:R1]->(n2:Genus) WITH 
            { 
                name:n.name, 
                genus_specie: n2.genus_specie
            } AS productDetails RETURN productDetails ORDER BY n.name
            SKIP 0 LIMIT 50

When I execute it says

Neo.ClientError.Statement.SyntaxError: Variable `n` not defined (line 5, column 74 (offset: 220)) " } AS essentialOilDetails RETURN essentialOilDetails ORDER BY n.name" ^
2

Hi,

The variable n must be listed in the WITH clause in order for it to be available to the ORDER BY clause.

3

I solved it. It's working now I just had to replace n.name with productDetails.name, thanks for the reply. :slight_smile: