# How to filter in elasticsearch?

**URL:** <https://discuss.elastic.co/t/how-to-filter-in-elasticsearch/305892>\
**Category:** Elasticsearch\
**Created:** [May 30, 2022, 4:35am UTC](https://discuss.elastic.co/t/how-to-filter-in-elasticsearch/305892 "2022-05-30T04:35:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RohitBR\_K](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rohitbr_k/32/103666_2.png) [@RohitBR\_K](https://discuss.elastic.co/u/RohitBR_K)\
**Post date:** [May 30, 2022, 4:35am UTC](https://discuss.elastic.co/t/how-to-filter-in-elasticsearch/305892/1 "2022-05-30T04:35:08Z")

</div>

```auto
                q = Q(
                    'bool',
                        # must_not=[Q('match', is_active="true"), Q('match', sales_block="False")],
                        must=[
                            Q(
                            'multi_match',
                            query = query,
                            fields = ['item_id.group_id._*name','item_id.group_id._name*','item_id.group_id.name_2gram','item_id.group_id.name_3gram','item_id.group_id.name','item_id.group_id.category_id.name','item_id.group_id.category_id.name_2gram','item_id.group_id.category_id.name_3gram','item_id.group_id.category_id._*name','item_id.group_id.category_id.name_*','item_id.name','item_id.name_2gram','item_id.name_3gram','item_id._*name','item_id.name_*''name','*_name','name_*','name._2gram','name._3gram','barcode_number','barcode_number._2gram','barcode_number._3gram','barcode_number_*','*_barcode_number'],
                            type="best_fields", #best_fields
                            max_expansions = 3,
                            boost=1,
                            fuzziness="0.6",
                            prefix_length=0,
                            slop=3,
                            operator="and"
                            # filter=[{'is_active':True,'sales_block':False}])
                            )
                        ]

                    )| Q(
                        'wildcard',
                        name={"value":f"*{query}"},
                    ) | Q(
                        'wildcard',
                        name={"value":f"{query}*"},
                    )
                search1 = search.query(q)
                search1 = search1.execute()
                v=NewsDocumentSerializer(search1,many=True)
                page = self.paginate_queryset(v.data)
                return Response ({'status':'success','response_code':200,"data":self.get_paginated_response(page)})

```

this is my query , but I need filteration ie, i need products that have is\_active=True and is\_active=False

---

<div class="post-metadata">

**Author:** ![RohitBR\_K](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rohitbr_k/32/103666_2.png) [@RohitBR\_K](https://discuss.elastic.co/u/RohitBR_K)\
**Post date:** [May 30, 2022, 6:50am UTC](https://discuss.elastic.co/t/how-to-filter-in-elasticsearch/305892/2 "2022-05-30T06:50:41Z")

</div>

got it !!

```auto

                        filter = [
                            {
                                "term":{
                                    "is_active":True
                                }
                            },
                            {
                                "term":{
                                    "is_delete":False
                                }
                            }
                        ]

```

may be useful for others....!!

---

<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:** [June 27, 2022, 6:51am UTC](https://discuss.elastic.co/t/how-to-filter-in-elasticsearch/305892/3 "2022-06-27T06:51:04Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.