Fulltext Index missing numeric properties

[alizadehei]

Hi,

I have created a fulltext index like so:

CALL db.index.fulltext.createNodeIndex("PersonIndex",["Person"],["age"])

the "age" is a numeric property. query on this index not worked.
If we consider age as a string property, then range searching like "age:[20 TO 30]" does not give the correct answer.

What is the best solution for storing numeric properties?

[stefan_armbrust · Accepted solution]

By design fulltext indexes operate solely on string properties, see https://neo4j.com/docs/cypher-manual/current/administration/indexes-for-full-text-search/.

You could either use a schema index (via CREATE INDEX ...) to index numeric values or convert the property values to strings and apply a full text index.