# Elasticsearch query to compute boolean conditions

**URL:** <https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285>\
**Category:** Elasticsearch\
**Created:** [January 20, 2017, 10:44am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285 "2017-01-20T10:44:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![siddharthgoel88](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharthgoel88/32/10616_2.png) [@siddharthgoel88](https://discuss.elastic.co/u/siddharthgoel88)\
**Post date:** [January 20, 2017, 10:44am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285/1 "2017-01-20T10:44:32Z")

</div>

We want to write an Elasticsearch search template something like following :

```
{
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": [
            {
              "term": {
                "variable1": "{{value1}}"
              }
            },
            {
              "or" : [
                {
                  "term" : {
                    "variable2" : "{{value2}}"
                  } 
                },
                {
                  "{{value2}}" is null
                }
                ]
            }
          ]
        }
      }
    }
  }
}

```

I am aware that the part where I wrote `"{{value2}}" is null` is invalid syntax. The result we want to achieve is that if the {{value2}} param passed to the search template is null then the search should only be filtered based on variable1 . So to achieve this kind of result how can I frame the query in ES ?

---

<div class="post-metadata">

**Author:** ![siddharthgoel88](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharthgoel88/32/10616_2.png) [@siddharthgoel88](https://discuss.elastic.co/u/siddharthgoel88)\
**Post date:** [January 22, 2017, 8:31am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285/2 "2017-01-22T08:31:54Z")

</div>

Hi @dadoonet . I see that you have a lot of contributions here so I thought to tag you directly here. Sorry for that. But do you have an idea how can I solve the problem I mentioned above?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [January 22, 2017, 10:21am UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285/3 "2017-01-22T10:21:24Z")

</div>

Not sure. may be you can find something useful there: [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-template.html#\_conditional\_clauses](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-template.html#_conditional_clauses)

---

<div class="post-metadata">

**Author:** ![siddharthgoel88](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharthgoel88/32/10616_2.png) [@siddharthgoel88](https://discuss.elastic.co/u/siddharthgoel88)\
**Post date:** [January 22, 2017, 3:39pm UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285/4 "2017-01-22T15:39:03Z")

</div>

Thanks @dadoonet . I have already checked it but did not find my solution there. But thanks for the reply 🙂

---

<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:** [February 19, 2017, 3:39pm UTC](https://discuss.elastic.co/t/elasticsearch-query-to-compute-boolean-conditions/72285/5 "2017-02-19T15:39:27Z")

</div>

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