# Filter with scripted field

**URL:** https://discuss.elastic.co/t/filter-with-scripted-field/267673
**Category:** Kibana
**Created:** [March 18, 2021, 1:47pm UTC](https://discuss.elastic.co/t/filter-with-scripted-field/267673 "2021-03-18T13:47:07Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Mahibul](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@Mahibul](https://discuss.elastic.co/u/Mahibul)
#### Post date: [March 18, 2021, 1:47pm UTC](https://discuss.elastic.co/t/filter-with-scripted-field/267673/1 "2021-03-18T13:47:07Z")

</div>

Hi,

I have created a scripted field test and the script is

```auto
if (params['_source']['additional'] == null) {
   return -1
}
return params['_source']['additional'].length()

```

The type of the field is number.  
This works fine in the sense that i can see the field and its correct value in discover. But when i try to apply filter of between i.e test: 10 to 100 i get an the below error

Error executing Painless script: 'boolean gte(Supplier s, def v) {return s.get() \>= v} boolean lt(Supplier s, def v) {return s.get() \< v}gte(() -\> { if (params['\_source']['additional'] == null) { ...'.

Would someone please let me know how can i get this working.  
Thanks in advance.

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [March 18, 2021, 10:55pm UTC](https://discuss.elastic.co/t/filter-with-scripted-field/267673/2 "2021-03-18T22:55:15Z")

</div>

What is your elastic version?

> <https://github.com/elastic/kibana/issues/39455>
>
> Kibana version: 7.2.0 BC10
> Elasticsearch version: 7.2.0 BC10
> Browser version: chrome latest
> Original install method (e.g. download page, yum, from source, etc.): from staging
> Describe...

---

<div class="post-metadata">

### Author: ![Mahibul](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@Mahibul](https://discuss.elastic.co/u/Mahibul)
#### Post date: [March 20, 2021, 12:58pm UTC](https://discuss.elastic.co/t/filter-with-scripted-field/267673/3 "2021-03-20T12:58:29Z")

</div>

I am using OpenDistro for Elasticsearch 1.13.1 which uses ElasticSearch version 7.10.2

> **[Version History](https://opendistro.github.io/for-elasticsearch-docs/version-history/)**
>
> Documentation for Open Distro for Elasticsearch, the community-driven, 100% open source distribution of Elasticsearch with advanced security, alerting, deep performance analysis, and more.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 17, 2021, 12:58pm UTC](https://discuss.elastic.co/t/filter-with-scripted-field/267673/4 "2021-04-17T12:58:29Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.