I am trying to run a cypher request where I need to compare the value stored as String, but when I use the function toFloat, I get an error:
Unknown function 'toFloat' (line 2, column 7)
"WHERE toFloat(r.acquiredValue) >= 100000"
^
I use Neo4j 2.0.1, and according to the Neo4j Cypher Refcard function exists, and even if I look at the source code of the community edition, I can find that the function is written.
Have you ever had this mistake? How to convert string to float in cypher request? Thank.
EDIT: Here is a query trying to run
MATCH (profile)<-[:HAS_PROFILE]-(c:Customer)-[r:HAS_PRODUCT]->(product)
WHERE toFloat(r.acquiredValue) >= 100000
RETURN c.customerId AS CustomerID, profile.code AS ProfileCode, product.name AS ProductName, r.acquiredValue AS AcquiredValue
ORDER BY r.acquiredValue DESC
source
share