Folks, in Prisma v2 how I use query if a type has entries? I’m not getting with this query:

prisma.category.findMany({
  where: {
    basket: {
      where: {
        food: {
          where: {
            id: true
          }
        }
      }
    }
  }
})

prisma.category.findMany({
  where: {
    basket: {
      where: {
        food: {
          where: {
            id: { not: null }
          }
        }
      }
    }
  }
})

is that what you meant?

Don’t work, this

food

it’s actually is plural, or array

have you tried something like

prisma.food.findMany({ where: <filter for food> } }).basket().category()

I get error

Expected at most 1 item for 'category', got 6

Does this work @Adriano Resende?

prisma.category.findMany({
  where: {
    basket: {
      where: {
        food: {
          where: {
            some: {
              id: { not: null }
            }
          }
        }
      }
    }
  }
})

https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/crud#type-1

@Jack Not work =/ The best I could get was like this:

prisma.category.findMany({
  where: {
    baskets: {
      some: {
        foods: {
          some: {
            published: true
          }
        }
      }
    }
  }
})

Could try

every

instead? Not 100% sure what final result you're aiming for tbh!

Return with empty too =/ I’ll create an issue on github