Can't use params in request using "WHERE IN {params}"

Question

Can't use params in request using "WHERE IN {params}"

Opened this issue 11 years ago · 2 comments

Here is an example of query

Keymaker.service.execute_cypher("START n=node:skillindex('*:*') MATCH (n)-[:belongsTo]->(x)<-[:belongsTo]-(y) , n-[:relatedTo*2..2]-y WHERE n.name IN [{names}] RETURN DISTINCT y limit 12", {names: skill_names})

I also tried {names: skill_names.map{|skill| "'#{skill}'"}.join(', ')}), IN [{names}] and just IN {names}

Answer 1 · 2013-06-05T05:09:16.000Z

And this query runs fine on the neo4j console?

Answer 2 · 2013-06-05T11:09:54.000Z

Yes, so I had to do something like this

Keymaker.service.execute_cypher("START n=node:skillindex('*:*') MATCH (n)-[:belongsTo]->(x)<-[:belongsTo]-(y) , n-[:relatedTo*2..2]-y WHERE n.name IN [#{skill_names}] RETURN DISTINCT y limit 12", {})