Deep Elasticsearch wildcard query for given time range and with AND operator

Question

I managed to build query that

matches all exact values in given time range
supports and operator.

Now I want to extend the query to support partial matching but I struggle to do that. Any advice would be appreciated.

Mapping

"event": {
    "properties": {
        "alarmId": {
            "type": "string",
            "index": "not_analyzed"
        },
        "startTimestamp": {
            "type": "long"
        },
        ...
    }
}

Current query

{
    "bool": {
        "must":[
            {"range": {"endTimestamp": {"gte": ?0}}},
            {"range": {"startTimestamp": {"lte": ?1}}}
        ],
        "should": [
            {"match": {"_all": {"query": "?2", "zero_terms_query": "all", "operator": "and"}}}
        ],
        "minimum_should_match" : 1
    }
}

This answer should help: http://stackoverflow.com/questions/37315275/elasticsearch-search-for-parts-of-words — Val, May 19 '16 at 09:31
@Val Interesting, It might work, but why there are dots in the query? `'*'.$val.'*` — rebeliagamer, May 19 '16 at 09:45
That's the string concatenation operator in PHP :) In your case that doesn't apply, simply use `"whatever*"` — Val, May 19 '16 at 09:46

score 0 · Accepted Answer · edited May 23 '17 at 11:53

0

Answer (thanks to Val)

{
    "bool": {
        "must":[
            {"range": {"endTimestamp": {"gte": ?0}}},
            {"range": {"startTimestamp": {"lte": ?1}}}
        ],
        "should": [
            {"query_string": {"query": "?2"}}"
        ],
        "minimum_should_match" : 1
    }
}

Now query supports grouping, wildcards and more.

edited May 23 '17 at 11:53

Community

1
1

answered May 19 '16 at 10:04

rebeliagamer

1,257
17
33

Deep Elasticsearch wildcard query for given time range and with AND operator

1 Answers1