How to use parameter in neo4j cypher query

Question

The Cypher official documentation seems to be inconsistent and misleading when it comes to assigning parameter values..we have the following examples in the refcard:

SET n.property1 = $value1

where value1 is a parameter defined

{
 "value1": somevalue
}

However if you use this SET syntax you get an error value1 not defined. The correct syntax seems to be:

SET n.property1 = {value1}

also if its a MATCH query the parameter looks like this:

  {
     email: someemail
    }

note no quotes around email So if you have a MATCH and SET query with parameters you parameters definition looks like this:

{
email: someemail,
"status" : somestatus
}

Can someone explain this apparent inconsistency?

EDIT: This is also an example from the neo4j docs:

using parameter with SET clause:

{
  "surname" : "Taylor"
}

MATCH (n { name: 'Andres' })
SET n.surname = $surname
RETURN n

This returns surname undefined.

What version of Neo4j are you using? The $ syntax for params in Cypher was introduced in 3.x — William Lyon
– William Lyon, Commented Apr 5, 2017 at 16:37
According to this, the $ syntax is valid from 3.1. Can you show how you are passing the parameters? — cybersam
– cybersam, Commented Apr 5, 2017 at 19:02
@cybersam you maybe right. I didn't actually run the 3.1 test as yet. So the 3.x according to William would not be correct....It would be 3.1+. for it to work I had to use the {value} which is not stated in the documentation that I saw.....maybe in some other documentation. And what with the different use of quotes("") when assigning values to the parameters? — MichaelE
– MichaelE, Commented Apr 5, 2017 at 20:24
Quotation depends, in part, on what language you are using to make your queries. Can you show the code you are using to pass the parameters? — cybersam
– cybersam, Commented Apr 5, 2017 at 20:38

Mathieu de Lorimier · Accepted Answer · 2018-03-26 22:00:32Z

4

You can set params in neo4j desktop browser using :params.

For eg,

Execute, :params {surname: 'Taylor'}
Execute, MATCH (n { name: 'Andres' }) SET n.surname = $surname RETURN n

For more info of params, use :help params

edited Mar 26, 2018 at 22:00

Mathieu de Lorimier

1,0153 gold badges20 silver badges33 bronze badges

answered Mar 26, 2018 at 18:53

Vaibhav Srivastava

412 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use parameter in neo4j cypher query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related