Breaking change in property WHERE evaluation - seems to treat as collection
Yossi Cadaner
MATCH (o:Organization)-[profile:ORG_ADMIN]-(u:User)
WHERE toLower(u.firstName) CONTAINS toLower('a')
RETURN u
This fails telling me
Expected a string value for
toLower
, but got: StringArray[Nechemia, Mendi, Shainy, Chana, Yosef Y., Chanie, Menachem, Aaron, Levi, Menachem Mendel]; consider converting it to a string with toString().However, this runs without any issue:
MATCH (u:User)
WHERE toLower(u.firstName) CONTAINS toLower('a')
RETURN u
Gregory King
Hey,
It looks like somehow your user objects are returning arrays of strings for firstName. You might want to try using the valueType function to inspect/debug properties and observe what's happening.
https://neo4j.com/docs/cypher-manual/current/functions/scalar/#functions-valueType