QueryStringQuery for date range and integers

Elastic Stack Elasticsearch
1

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) like:

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

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

2

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]
3

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.

4

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

5

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