# Is there a way to perform conditional filter WHERE prop NOT ContainsAny (:excludedValues)?

**URL:** <https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260>\
**Category:** Support\
**Created:** [May 10, 2024, 1:36pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260 "2024-05-10T13:36:09Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![junbetterway](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/junbetterway/32/174_2.png) [@junbetterway](https://forum.weaviate.io/u/junbetterway)\
**Post date:** [May 10, 2024, 1:36pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/1 "2024-05-10T13:36:09Z")

</div>

### Description

Is there a way to perform conditional filter WHERE prop NOT ContainsAny (:excludedValues)?

### Any additional Information

Let’s say we have a `UserProfile` vector schema with a property of sourceId for each profile and I wanted to only include results where sourceId is **not contains in any :excludeIds** ( **e.g.,** 1,2,3,4, so on…)

I just saw this open feature request: [[Feature Request] Add "Not" operator in filter to support "Not Like" etc. in Get queries · Issue #3683 · weaviate/weaviate · GitHub](https://github.com/weaviate/weaviate/issues/3683) and sadly looks like it has no movements/updates ☹

Are there any possible workaround to achieve this? Thanks!

---

<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 10, 2024, 5:42pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/2 "2024-05-10T17:42:04Z")

</div>

hi @junbetterway !

As per our docs:

> **[Conditional filters | Weaviate - Vector Database](https://weaviate.io/developers/weaviate/api/graphql/filters#filter-structure)**
>
> Overview

An operator to invert a filter (e.g. `Not Like ...` ) is not supported in Weaviate. If you would to see such an operator to be implemented, please let us know by [upvoting the issue here](https://github.com/weaviate/weaviate/issues/3683).

Thanks!

---

<div class="post-metadata">

**Author:** ![junbetterway](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/junbetterway/32/174_2.png) [@junbetterway](https://forum.weaviate.io/u/junbetterway)\
**Post date:** [May 11, 2024, 12:55am UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/3 "2024-05-11T00:55:09Z")

</div>

Thanks @DudaNogueira and yeah saw that one already and upvoted it too.

Do you know if there has been progress about it? We’re really dying to have such as we have this new feature and having this **NOT \*\*\* (or invert) condition** will make it more efficient.

---

<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 12, 2024, 1:33pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/4 "2024-05-12T13:33:56Z")

</div>

Not necessarily a progress, but we have recently released the [1.25 version with RAFT](https://github.com/weaviate/weaviate/releases/tag/v1.25.0) that required a lot of effort from our team.

With that finished, I believe we’ll have more capacity to tackle those feature requests.

Also, I have seen some internal discussions on that exact subject, so hopefully we get a solution for this soon.

---

<div class="post-metadata">

**Author:** ![junbetterway](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/junbetterway/32/174_2.png) [@junbetterway](https://forum.weaviate.io/u/junbetterway)\
**Post date:** [May 13, 2024, 1:47pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/5 "2024-05-13T13:47:15Z")

</div>

Thanks @DudaNogueira that’s great to hear.

---

<div class="post-metadata">

**Author:** ![Beck](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/beck/32/1882_2.png) [@Beck](https://forum.weaviate.io/u/Beck)\
**Post date:** [November 30, 2024, 7:52am UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/6 "2024-11-30T07:52:40Z")

</div>

@DudaNogueira any news about it?

---

<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:** [December 2, 2024, 8:20pm UTC](https://forum.weaviate.io/t/is-there-a-way-to-perform-conditional-filter-where-prop-not-containsany-excludedvalues/2260/7 "2024-12-02T20:20:20Z")

</div>

We have indeed!!

no ETA, but heard this week from our team about it specific issue, so we should get some updates on the GH issue in the next days.

Thanks and sorry for the delay here 😬 .
