5 replies

How to filter query based on children table?

Hi friends, first time using Drizzle so be gentle, this question may be dumb.

I designed a model where I have a country table and a country_language table, as you can see in the attachment.

Let's say that I want to return the country which has the slug (from the country_language table)="portugal-en". How can I write that expression?

Here's my try:

const country = await db.query.countries.findFirst({
  with: {
    countryLanguages: {
      where: eq(countryLanguages.slug, countrySlug),
    }
  },
});

const country = await db.query.countries.findFirst({
  with: {
    countryLanguages: {
      where: eq(countryLanguages.slug, countrySlug),
    }
  },
});

However, this is returning the first country and then just filtering the country_languages table, which is not what I want. I tried to move the where clause to the country level, but didn't worked, since that column (slug) does not exist on the country table).

Thank you!

Drizzle Team•3y ago•

5 replies

Nelson Sousa

How to filter query based on children table?

const country = await db.query.countries.findFirst({
  with: {
    countryLanguages: {
      where: eq(countryLanguages.slug, countrySlug),
    }
  },
});

const country = await db.query.countries.findFirst({
  with: {
    countryLanguages: {
      where: eq(countryLanguages.slug, countrySlug),
    }
  },
});

How to filter query based on children table?

Similar Threads

How to filter query based on children table?

Similar Threads

Similar Threads

Similar Threads