# Must command not working

**URL:** <https://discuss.elastic.co/t/must-command-not-working/7738>\
**Category:** Elasticsearch\
**Created:** [May 17, 2012, 6:33am UTC](https://discuss.elastic.co/t/must-command-not-working/7738 "2012-05-17T06:33:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vipul](https://avatars.discourse-cdn.com/v4/letter/v/cdc98d/32.png) [@Vipul](https://discuss.elastic.co/u/Vipul)\
**Post date:** [May 17, 2012, 6:33am UTC](https://discuss.elastic.co/t/must-command-not-working/7738/1 "2012-05-17T06:33:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 3:28am UTC](https://discuss.elastic.co/t/must-command-not-working/7738/2 "2017-07-06T03:28:23Z")

</div>