# Getting documents based on field length
**URL:** https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178
**Category:** Elasticsearch
**Created:** [February 13, 2019, 10:05am UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178 "2019-02-13T10:05:25Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@saqibjavid](https://discuss.elastic.co/u/saqibjavid)
#### Post date: [February 13, 2019, 10:05am UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/1 "2019-02-13T10:05:25Z")
I have uploaded nearly 1,000,000 JSON files into elastic search. I am looking for a query which will help me filter and return documents based on a condition of field length using kibana.
For example I have a field of phone numbers in my files, so I want to get only those files which consists of phone number length greater than 10, where (phone:) is the field. This must be done using kibana. Please assist me in it.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [February 13, 2019, 10:31am UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/2 "2019-02-13T10:31:47Z")
You should compute that value at index time. Like:
```auto
{
"phone": "xyz",
"phone_length": 3
}
```
You can do that at index time using a [painless script processor](https://www.elastic.co/guide/en/elasticsearch/reference/6.6/script-processor.html).
If you really want to run that at search time, you can use a [Script Query](https://www.elastic.co/guide/en/elasticsearch/reference/6.6/query-dsl-script-query.html). But this will be slow to run IMO.
---
### Author:  [@saqibjavid](https://discuss.elastic.co/u/saqibjavid)
#### Post date: [February 13, 2019, 11:03am UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/3 "2019-02-13T11:03:40Z")
Can you give me a sample script query for retrieving the files with phone: whose length is greater than 10
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [February 13, 2019, 11:32am UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/4 "2019-02-13T11:32:46Z")
No sorry. I don't use Painless myself.
---
### Author:  [@saqibjavid](https://discuss.elastic.co/u/saqibjavid)
#### Post date: [February 13, 2019, 12:01pm UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/5 "2019-02-13T12:01:02Z")
Thankyou so much @dadoonet
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 13, 2019, 12:01pm UTC](https://discuss.elastic.co/t/getting-documents-based-on-field-length/168178/6 "2019-03-13T12:01:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.