Must command not working


(Vipul) #1

Hi, 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


(system) #2