Prisma findMany with 2 fields from array

Question

I am using Prisma and I have two field values that I want to search on

const requests = [{ id, cid }, { id, cid }, { id, cid }];

I want to search on both fields together but for many.

for(request of requests) {
    prisma.user.findFirst({
        where: {
            id: request.id,
            cid: request.cid
        }
    });
}

Basically I want to do the above query but for many pairs at once. How to do that?

score 4 · Answer 1 · answered Feb 21 '22 at 07:14

4

You are looking for in operator.


const requests = [{ id, cid }, { id, cid }, { id, cid }];

const ids = requests.map((request)=>request.id);
const cids = requests.map((request)=>request.cid);

const getUser = await prisma.user.findMany({
  where: {
    id: { in: ids },
    cid: { in: cids }
  },
})

Here is a link to in operator documentation

answered Feb 21 '22 at 07:14

Nurul Sundarani

5,550
3
23
52

I am asking for data to be used in pairs, not any id and any cid – Vinit Khandelwal Mar 01 '22 at 03:26
what about the cross results of the id and cid? What I mean to say is that we have to search in pairs. – Harsh Gupta May 03 '23 at 12:25

Prisma findMany with 2 fields from array

1 Answers1