Re: How to use parameters in "Neo4j Cypher"?

[podunk]

 

Thank you very much for help - it works.

U're right obout parameter names - here it was productId not productid :-)

 

Sent: Tuesday, March 12, 2024 at 12:02 PM
From: "Geoffrey Cleaves" <gclea...@gmail.com>
To: users@hop.apache.org
Subject: Re: How to use parameters in "Neo4j Cypher"?

Try simply $productid. 

 

Beware that Hop is opinionated about what your parameters should look like and will rewrite field names which have an underscore. For example, field my_field will be renamed to myField in the Neo4j Cypher transform. 
 

On Tue, 12 Mar 2024, 10:18 , <pod...@gmx.com> wrote:

 

Hello dear Hop users!

 

Could you please tell me how to use parameters in "Neo4j Cypher"?

In Parameters tab I have:

 

productid (parameter), product_id (Field), Integer (Neo4j Type)

'product_id' comes from csv file collumn - hop earlier.

 

My query is something like:

 

MATCH path = (....)

WHERE (product.product_id = {productid})

 

 

Does not work although according to manual, 'parameter substitution (for example {MY_PARAMETER}' it should: https://hop.apache.org/manual/latest/pipeline/transforms/neo4j-cypher.html

I tried also:

 

WHERE (product.product_id = ${productid})

WHERE (product.product_id = ?)

 

None works

 

So, what is the correct syntax?

 

Regards!