hello guys im trying to return the number of records nested in one model on my database but i am not finding a way. where i want just the number of record where notifications is dismissAt null. but i just want the number not the whole thing.

const user = await this.prismaService.user.findUnique({
      where: {
        id: userId,
      },
      select: {
        managing: {
          select: {
            user: {
              select: {
                person: true,
              },
              include: {
                notifications: {
                  where: {
                    dismissAt: null,
                  },
                },
              },
            },
          },
        },
      },
    });

Hi @Clément Guibout 👋 Can you try using this and let me know if it works for you?

const user = await this.prismaService.user.findUnique({
    where: {
      id: userId,
    },
    select: {
      managing: {
        select: {
          user: {
            select: {
              person: true,
            },
            select: {
              _count: {
                select: {
                  notifications: {
                    where: {
                      dismissAt: null,
                    },
                  },
                }
                
              }
              
            },
          },
        },
      },
    },
  });

it work we just have to use "filteredRelationCount" as a preview feature

You're welcome.