cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Parameter in Cypher cause warning

Hi,

First off, I set the parameter:
3X_c_5_c56a438a2c55c692c89ea9be339c7f6e0a3da47e.png
And then I use the parameter but it has the following warning.

The statement refers to a parameter that was not provided in the request.
Did not supply query with enough parameters. The produced query plan will not be cached and is not executable without EXPLAIN. (Missing parameters: org_id)

Can anyone tell me why and how I fix this?

Thanks!

1 ACCEPTED SOLUTION

Hello @mading0817

I can't tell in details what are the consequences, but for now Neo4j is telling you that it doesn't like the fact that you are using a parameter directly as a returning value.

This might cause performance issues in the query planning.

MATCH (o:Org)
WHERE o.id = $org_id
RETURN o.id, o.name

DO NOT return the $org_id, it's useless anyway you already have it in your o.id result's column.

View solution in original post

3 REPLIES 3

Hello @mading0817

I can't tell in details what are the consequences, but for now Neo4j is telling you that it doesn't like the fact that you are using a parameter directly as a returning value.

This might cause performance issues in the query planning.

MATCH (o:Org)
WHERE o.id = $org_id
RETURN o.id, o.name

DO NOT return the $org_id, it's useless anyway you already have it in your o.id result's column.

That looks buggy to me. I think our browser team would want to take a look at this. What version of the browser is being used? If you click the Neo4j icon in the lower left sidebar it should show the versions.

I am using neo4j desktop the version I cannot recall, sorry
But I always update the desktop as soon as it release new version