Is it not possible to filter by a M2M field on a collection? | Directus | Page 1

north iglooBOT Mar 20, 2023, 1:43 PM

#

Thanks for posting! This is a community powered server, so you may or may not get an answer based on available help and expertise. To increase your chances of somebody being able to help you, please make sure your question includes the following:

An explanation of exactly what you're trying to achieve.
Any and all related code or previous attempts.
The exact issue or error you are facing.
Any screenshots if applicable.

When you're done with this thread, please close it.

(If you have a support agreement and need help, please contact the core team via email.)

open narwhal Mar 21, 2023, 5:22 AM

#

Is there a way to bump this for my sanity

sleek rune Mar 21, 2023, 12:05 PM

#

What version are you on?

#

Directus does support this. Docs are here: https://docs.directus.io/reference/filter-rules.html#relational

Filter Rules | Directus Docs

REST and GraphQL API documentation for filter rules in Directus.

open narwhal Mar 21, 2023, 2:43 PM

#

Hello! Thank you for the response i am on 9.23.1

#

Another example, since I deleted.

#

I've used Directus for a couple of years, and i could have sworn filtering did work on m2m relationships

#

Seems to work fine for searching just one term, but it does not work for multiple terms

sleek rune Mar 21, 2023, 6:37 PM

#

What type of field is 'slug'? It looks like checkbox. I think the issue is searching checkbox fields.

#

not related to the M2M. you can search the "genres" collection directly to test

open narwhal Mar 21, 2023, 6:45 PM

#

The slug feild is just a string value that exists on the Genre collection, its a slugified title basically.

#

So it should be searchable 🙂

#

I must be missing something

sleek rune Mar 22, 2023, 11:20 AM

#

so you're manually typing "retro,future-base,soul"?

#

Can you open up the "Genres" collections and test a search from there. It would be good to workout if this is related to the M2M or not

open narwhal Mar 22, 2023, 4:30 PM

#

#

Yeah it works fine when filtering the genre collection

sleek rune Mar 22, 2023, 5:15 PM

#

looks like this issue is actually just related to the "doesn't contain" option

#

There is a bug reported on this one.. https://github.com/directus/directus/issues/5996

GitHub

_ncontains doesn't work on o2m nested dataset · Issue #5996 · direc...

Filter not working properly on nested items (on many to one or one to many) Left column: ID id: 110 Right column: Jakso (info from another collection) id: 110 --> 1/2021, 2/2021, 3/2021 Trying t...

open narwhal Mar 22, 2023, 7:02 PM

#

Is this also a bug? There should be at least one result since one item contains both soul and retro

#

Doesnt seem like there is a good way to return results for items that only include for example "soul" and "retro"

#

sleek rune Mar 23, 2023, 10:28 AM

#

I also found this issue which looks relevant to your use case https://github.com/directus/directus/issues/13252

GitHub

Can not use multiple filters/deeps · Issue #13252 · directus/direc...

Describe the Bug Making a REST request with 2 or more filters/deeps on a datamodel having "many-to-many" relation fails. Using a single filter/deep works perfectly fine. To Reproduce Crea...

#Is it not possible to filter by a M2M field on a collection?