Deep filtering nested relations Directus

Question

How do I use deep in nested relations?

deep: {
    translations: { _filter: { languages_code: 'nl-NL' } },
    variants: { _filter: { translations: { languages_code: 'nl-NL' } } }, // This does not work
}

The object that I try to filter looks as this

I am trying to filter out translations inside the variants aswell. But the above query does not work.

{
    // WORKS: translations: { _filter: { languages_code: locals.language } }
    translations: [
        {
            id: 7,
            products_id: 1,
            languages_code: 'nl-NL', // locals.language = nl-NL
            title: '...',
            description: '...',
            slug: '...',
            variantTitle: null,
        },
    ],
    // DOES NOT WORK: variants: { _filter: { translations: { languages_code: locals.language } } } 
    // I guess it does not work since translations is an array inside variants
    // which is also an array
    variants: [
        {
            id: 1,
            product: 1,
            translations: [
                {
                    id: 1,
                    product_variants_id: 1,
                    languages_code: 'nl-NL',
                    title: 'Aantal',
                },
                {
                    id: 2,
                    product_variants_id: 1,
                    languages_code: 'en-US', // This object should be left out of the result
                    title: 'Amount',
                },
            ],
            products: [2, 3],
        },
    ],
}

Gergely Simándi · Accepted Answer · 2024-12-11 08:27:55Z

1

If I understand correctly you have a collection that contains variants that contains translations and you try to filter the list of translations when reading the root collection.

In this case the following query should work (REST):

deep = {
  "variants": {
    "translations": {
      "_filter": {
        "languages_code": {
          "_eq": "EN"
        }
      }
    }
  }
}

answered Dec 11, 2024 at 8:27

Gergely Simándi

535 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Red Dec 11, 2024 at 12:01

I already had my answer with the help of discord, but yes, this was it indeed.

Collectives™ on Stack Overflow

Deep filtering nested relations Directus

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related