I want to ask a problem about a relationship screening

[1422094090]

i want to screening the transaction's amount greater than 50000,here is my cypher"
match (a)-[r:transaction]->(b)
where tofloat(r.amount)>=50000
return a,r,b" but when i run the cypher,the graph still shows the transaction which amount is less than 50000，like this

what is the problem
? thanks a lot

[glilienfield (Gary Lilienfield)]

By default, the browser shows all relationships between all nodes returned. You can turn this feature off in the browser settings.

See “connect result nodes” setting in screenshot below. Uncheck it.

[dana_canzano]

@1422094090

also and its unclear from the initial description but if Neo4j v5x if you have a relationship index

CREATE INDEX rel_range_txn_amount FOR ()-[r:transaction]-() ON (r.amount)

then

@1422094090

match (a)-[r:transaction]->(b)
where r.amount>=50000
return a,r,b

will be much more performant. Note, if you include the to_float() then the index is not utilized

[1422094090]

awesome bro，it really helps me!!!

[1422094090]

it looks like" create index" is much more convenient, i will try ,thanks!