# Dynamically combine multiple filters

**URL:** https://forum.weaviate.io/t/dynamically-combine-multiple-filters/2281
**Category:** Support
**Tags:** python
**Created:** [May 12, 2024, 10:29pm UTC](https://forum.weaviate.io/t/dynamically-combine-multiple-filters/2281 "2024-05-12T22:29:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Amit](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/amit/32/445_2.png) [@Amit](https://forum.weaviate.io/u/Amit)
#### Post date: [May 12, 2024, 10:29pm UTC](https://forum.weaviate.io/t/dynamically-combine-multiple-filters/2281/1 "2024-05-12T22:29:40Z")

</div>

I would like to dynamically combine multiple filters in the same query.

For example, I have a list of md5s that I would like to include in a filter,

`md5_list = ['md5_value_1', 'md5_value_2', 'md5_value_3', ...]`

I would like to prepare an OR filter using all these md5 values and then run my query. Essesstially something like this.

```auto
## The code below is just to show what I am trying to achieve.

# List of md5 values
md5_list = ['md5_value_1', 'md5_value_2', 'md5_value_3', ...]

# Create a list of filters for each md5 value
filters = [wvc.query.Filter.by_property("md5").equal(md5) for md5 in md5_list]

# Combine the filters using the bitwise OR operator
combined_filter = "Or".join(filters)

# Use the combined filter in the query
vecDB_response = documentCollection.query.near_vector(
    near_vector=questionsVectorQuery,
    filters=combined_filter,
    limit=10,
    return_metadata=MetadataQuery(distance=True)
)

```

Any ideas how to achieve this? Any help would be appreicated.

Thanks  
A

---

<div class="post-metadata">

### Author: ![Amit](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/amit/32/445_2.png) [@Amit](https://forum.weaviate.io/u/Amit)
#### Post date: [May 12, 2024, 10:40pm UTC](https://forum.weaviate.io/t/dynamically-combine-multiple-filters/2281/2 "2024-05-12T22:40:23Z")

</div>

```auto
        md5_list = ['md5_value_1', 'md5_value_2', 'md5_value_3']

        vecDB_response = documentCollection.query.near_vector(
            near_vector=questionsVectorQuery,
            filters=wvc.query.Filter.by_property("md5").contains_any(md5_list),
            limit=10,
            return_metadata=MetadataQuery(distance=True)
        )

```

Yet again. Asked a bit too soon.

---

<div class="post-metadata">

### Author: ![DudaNogueira](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/dudanogueira/32/7846_2.png) [@DudaNogueira](https://forum.weaviate.io/u/DudaNogueira)
#### Post date: [May 14, 2024, 1:11pm UTC](https://forum.weaviate.io/t/dynamically-combine-multiple-filters/2281/3 "2024-05-14T13:11:07Z")

</div>

hi @Amit !!

Thanks for sharing 🙂