has anyone experienced problem with `some` query w...
# prisma-client
u
has anyone experienced problem with
some
query with mongodb connector?
Copy code
const list = await this.prisma.workspace.findMany({
      where: {
        members: {
          some: {
            user: {
              uid: uid,
            },
          },
        },
      },
      include: {
        members: true,
      },
    });
    return list;
returns [] (no data)
Copy code
const list = await this.prisma.workspace.findMany({
      where: {
        OR: [
          {
            members: {
              every: {
                user: {
                  uid: uid,
                },
              },
            },
          },
          {
            members: {
              some: {
                user: {
                  uid: uid,
                },
              },
            },
          },
        ],
      },
    });
    return list;
=> returns [a, b, c, …]
👀 1
a
Hey uzu, Could you provide some sample data for the models you’re querying? It seems unexpected at first glance, but before we report an issue I want to make sure. Thanks!