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 :"canceled" or "confirmed". Thanks in advance

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