# If else script filter does not work

**URL:** https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221
**Category:** Elasticsearch
**Created:** [March 12, 2016, 4:18am UTC](https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221 "2016-03-12T04:18:36Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![84shalinisingh](https://avatars.discourse-cdn.com/v4/letter/8/f17d59/32.png) [@84shalinisingh](https://discuss.elastic.co/u/84shalinisingh)
#### Post date: [March 12, 2016, 4:18am UTC](https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221/1 "2016-03-12T04:18:36Z")

</div>

Hi All,

I am using elastic search version 1.4.2.  
I am creating a scripted term as below.

```
"aggregations" : {
    "aggr~~derived_i~g" : {
      "terms" : {
        "script" : "if(doc['g'].value > 50) {'big sal'} else {'small sal'}",
        "size" : 0,
        "order" : {
          "_term" : "asc"
        }
      }

```

This works fine and I am able to fetch both the bucket values.  
Now I am trying to filter the terms, which doesn't work!

```
"query" : {
    "filtered" : {
      "query" : {
        "match_all" : { }
      },
      "filter" : {
        "and" : {
          "filters" : [ {
            "and" : {
              "filters" : [ {
                "not" : {
                  "filter" : {
                    "or" : {
                      "filters" : [ {
                        "script" : {
                          "script" : "doc['g'].value > 50 == param0 ",
                          "params" : {
                            "param0" : false
                          }
                        }
                      } ]
                    }
                  }
                }
              } ]
            }
          } ]
        }
      }
    }

```

while I change the param0 to true, it does not return the values as expected. It returns values with doc['g'].value \> 50 in both the cases.  
Script filter like  
`"script" : " !( doc['g'].value > 50 ) "`  
Will it work?

Thanks  
Shalini

---

<div class="post-metadata">

### Author: ![84shalinisingh](https://avatars.discourse-cdn.com/v4/letter/8/f17d59/32.png) [@84shalinisingh](https://discuss.elastic.co/u/84shalinisingh)
#### Post date: [March 14, 2016, 9:45am UTC](https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221/2 "2016-03-14T09:45:13Z")

</div>

Did someone face this issue, any help would be greatly appreciated.

Thanks  
Shalini

---

<div class="post-metadata">

### Author: ![84shalinisingh](https://avatars.discourse-cdn.com/v4/letter/8/f17d59/32.png) [@84shalinisingh](https://discuss.elastic.co/u/84shalinisingh)
#### Post date: [March 16, 2016, 3:56am UTC](https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221/3 "2016-03-16T03:56:06Z")

</div>

Any help would be greatly appreciated, As I am still to resolve this issue.

Thanks  
Shalini

---

<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: [July 5, 2017, 11:08pm UTC](https://discuss.elastic.co/t/if-else-script-filter-does-not-work/44221/4 "2017-07-05T23:08:02Z")

</div>