Failure with WHERE statement? (no changes, no records)

Neo4j Graph Platform Cypher
1

Hello,

I try to match some nodes with the following statement:

MATCH (e:event) 
WHERE e.process_PID = "433"
RETURN e.process_PID
LIMIT 10

RESPONSE:

(no changes, no records)

If I try this WITHOUT the where statement:

MATCH (e:event) 
RETURN e.process_PID
LIMIT 10

RESPONSE:

╒═══════════════╕
│"e.process_PID"│
╞═══════════════╡
│433            │
├───────────────┤
│743            │
├───────────────┤
│916            │
├───────────────┤
│935            │
├───────────────┤
│1062           │
├───────────────┤
│1081           │
├───────────────┤
│1093           │
├───────────────┤
│1145           │
├───────────────┤
│1160           │
├───────────────┤
│1177           │
└───────────────┘

How could I use the where statement to find the 433 e.process_PID for example?

Greetings Sebastian

2

You might have stored the value as a number and not as a string. Try this instead:

MATCH (e:event) 
WHERE e.process_PID = 433
RETURN e.process_PID
LIMIT 10
1 Like
3

Hi @schnur.sebastian, Solution by @stefan.armbruster is good and please remember about docs: WHERE - Cypher Manual . Your problems solutions was probably there.

4

Thx for the hint! I try to find more about the data types in Neo4j via cypher - is there another good site or link in the docs? I tried: Values and types - Cypher Manual
but there was no hint for the differences between string and integer.

5

The apoc library has apoc.meta.type(value) to return the type of a given value.