# QueryStringQuery for date range and integers

**URL:** <https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189>\
**Category:** Elasticsearch\
**Tags:** docker\
**Created:** [June 29, 2020, 8:34pm UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189 "2020-06-29T20:34:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![shahab78](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shahab78/32/68350_2.png) [@shahab78](https://discuss.elastic.co/u/shahab78)\
**Post date:** [June 29, 2020, 8:34pm UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189/1 "2020-06-29T20:34:29Z")

</div>

Hi, I have some Java code like this:  
`SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder(); QueryBuilder stringQuery = QueryBuilders.queryStringQuery(query); searchSourceBuilder.query(stringQuery);`  
I have fields like this in my index:  
`"runId" : { "type" : "text" }, "startedOn" : { "type" : "date", "format": "yyyy-MM-dd HH:mm:ss.SSSSSS" }, "versionId" : { "type" : "integer" },`

I can run queries like 'runId = something' and it works fine, but I am struggling to do the same for the integer ('versionId = 5'), or for date range following examples here ([https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html)) like:

`StartedOn : [2020-06-20 TO 2020-06-25]`

Is there something I'm missing, or are these not possible with QueryStringQuery?

---

<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:** [June 30, 2020, 8:18am UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189/2 "2020-06-30T08:18:26Z")

</div>

Could you share the code you're running for the version?  
BTW remove the space after the field name.

```
StartedOn:[2020-06-20 TO 2020-06-25]
```

---

<div class="post-metadata">

**Author:** ![shahab78](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shahab78/32/68350_2.png) [@shahab78](https://discuss.elastic.co/u/shahab78)\
**Post date:** [June 30, 2020, 12:40pm UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189/3 "2020-06-30T12:40:29Z")

</div>

I did it with no spaces, no luck.

I am using bulk update to update the documents, if that's what you are asking. Sorry I'm new I'm not very familiar with the lingo.

```
data = {
    "_index": index,
    "_op_type": 'update',
    "doc_as_upsert": True,
    "_id": document_id,
    "doc": doc. __dict__
}

res = bulk(es, es_messages, index=INDEX, raise_on_error=True)

```

I can do the query easily on Kibana, but not here.

---

<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:** [July 2, 2020, 9:37am UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189/4 "2020-07-02T09:37:23Z")

</div>

Could you share the full Java code which reproduces the problem and the query you are running in Kibana dev console which works?

---

<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 30, 2020, 9:37am UTC](https://discuss.elastic.co/t/querystringquery-for-date-range-and-integers/239189/5 "2020-07-30T09:37:31Z")

</div>

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