Filtered search in elasticsearch

Question

I am new to elasticsearch and I would like to do a filtered search: A part of my mapping is like this:

  "_index" : "project", 
  "_type" : "flat_order", 
  "_id" : "795", 
  "_score" : 2.1372108, 
  "fields" : { 
    "status" : "canceled", 
    "created_at" : "2012-01-04 12:48:48", 
    "updated_at" : "2012-02-21 07:19:35" 
  } 
}, { 
  "_index" : "project", 
  "_type" : "flat_order", 
  "_id" : "803", 
  "_score" : 2.1372108, 
  "fields" : { 
    "status" : "canceled", 
    "created_at" : "2012-01-04 12:50:54", 
    "updated_at" : "2012-02-21 07:19:35" 
  }

I want all the indices having created_at in a range gte:"2012-01-01 00:00:00",lte:"2012-02-01 00:00:00", and having status :"cancelled" or "confirmed".

Thanks in advance

Saeed Zhiany · Accepted Answer · 2016-12-01 15:46:01Z

1

got the solution:

$ curl -X GET http://localhost:9200/project/flat_order/_search?pretty=true -d '{
  "fields": [
    "created_at",
    "status"
  ],
  "query": {
    "filtered": {
      "query": {
        "range": {
          "create‌d_at": {
            "gte": "2012-01-01 00:00:00",
            "lte": "2012-02-01 00:00:00"
          }
        }
      },
      "filter": {
        "or": [
          {
            "term": {
              "status": "canceled"
            }
          },
          {
            "term": {
              "status": "con‌firmed"
            }
          }
        ]
      }
    }
  }
}

'

edited Dec 1, 2016 at 15:46

Saeed Zhiany

2,1419 gold badges34 silver badges44 bronze badges

answered May 18, 2012 at 8:09

Vipul

1951 gold badge4 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filtered search in elasticsearch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related