neo4j - How to use the int[] in where IN clause in Cypher Query (using C#)

Question

I have this cypher query

int[] pIds = new int[] {101, 012}; 
var query = _graphClient.Cypher.Read
            .OptionalMatch($"(p: {Labels.PERSON})")
            .Where($"p.Id IN [{pIds}]") 
            .Return<Person>(p);

On debugging it looks like this:

OPTIONAL MATCH (p: Person)
WHERE p.Id IN [System.Int32[]] 
RETURN distinct p

---

The values that I should pass in this where clause [101, 012], but its not. Because pIds[0] = 101, pIds[1] = 012 - and its never read in the cypher query.

Where am I going wrong and its failing to pass the values? How should I pass the int[] in the Where IN...

question from:https://stackoverflow.com/questions/65598673/how-to-use-the-int-in-where-in-clause-in-cypher-query-using-c

Answer 1

Best is probably to use parameters :

int[] pIds = new int[] {101, 012}; 
var query = _graphClient.Cypher.Read
            .OptionalMatch($"(p: {Labels.PERSON})")
            .Where($"p.Id IN $pIds") 
            .Return<Person>(p)
            .WithParam("pIds", pIds);