Where clause dependent on with relation

const news = await ctx.db.query.newsTable.findMany({
        limit: 20,
        offset: 20 * input.page,
        orderBy: (newsTable, { desc }) => [desc(newsTable.createdAt)],
        with: {
          tweets: {
            with: { pundit: true },
          },
        },
      });


So I want to add to this query where tweets.length > 0. But I don't know how to anchor on to this tweets relation
Was this page helpful?