# Combining script inline and stored within the same query

**URL:** <https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315>\
**Category:** Elasticsearch\
**Created:** [June 14, 2017, 7:32am UTC](https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315 "2017-06-14T07:32:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo\_Silva](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@Paulo\_Silva](https://discuss.elastic.co/u/Paulo_Silva)\
**Post date:** [June 14, 2017, 7:32am UTC](https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315/1 "2017-06-14T07:32:31Z")

</div>

Hi guys,

Is it possible to combine script inline and stored on the same query?

For example, I've got two queries: "Query 1" which calls a stored script and "Query 2" that is a dynamic script inline. How could I combine them in a single statement?

Query 1:  
{  
"query": {  
"script": {  
"script": {  
"lang": "painless",  
"id": "QuarterOfTheYearFilter",  
"params": {  
"dt\_field\_name": "MyDate",  
"timezone":"UTC",  
"reqList": ["02","04"]  
}  
}  
}  
}  
}

Query 2:  
{  
"query": {  
"script": {  
"script": {  
"lang": "painless",  
"inline": "ZonedDateTime.ofInstant(Instant.ofEpochMilli(doc['MyField'].value), ZoneId.of('{1}')).getDayOfMonth() = '01'"  
}  
}  
}  
}

Cheers!

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [June 14, 2017, 7:34am UTC](https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315/2 "2017-06-14T07:34:38Z")

</div>

Hey,

you would use a `bool` query, that contains those two queries within a `must` clause (if those should be combined with an AND).

See [https://www.elastic.co/guide/en/elasticsearch/reference/5.4/query-dsl-bool-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/5.4/query-dsl-bool-query.html)

--Alex

---

<div class="post-metadata">

**Author:** ![Paulo\_Silva](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@Paulo\_Silva](https://discuss.elastic.co/u/Paulo_Silva)\
**Post date:** [June 14, 2017, 11:44pm UTC](https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315/3 "2017-06-14T23:44:58Z")

</div>

Thanks Alex, I 'll try.

---

<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 12, 2017, 11:45pm UTC](https://discuss.elastic.co/t/combining-script-inline-and-stored-within-the-same-query/89315/4 "2017-07-12T23:45:02Z")

</div>

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