CODEWITHSUNDEEP
solrlucene
snakile
snakile

Reputation: 54541

String length function query in Solr

I need to find all the documents in my collection for which the length of a certain field exceeds a certain limit. The field's type is string. Is there a function query that returns the length of a string field in Solr?

Upvotes: 14

Views: 16722

Answers (2)

snakile
snakile

Reputation: 54541

The solution is to use Solr's regex capabilities. For example, the following query retrieves all the documents for which the title field is at least 42:

title:/.{42}.*/

Upvotes: 38

mindas
mindas

Reputation: 26733

Querying by length is not supported out of the box, the most sensible way would be to create a separate (numeric) field and query by this field.

Upvotes: 2

Related Questions