model Campaign {
  id               String             @id @default(uuid())
  company          Company            @relation(fields: [companyId], references: [id])
  companyId        String
}
model Company {
  id               String @id @default(uuid())
  Campaign         Campaign[]
}
------------------

await prisma.campaign.updateMany({
    where: { id: campaignId, companyId },
    data: { ...data }
});

I have to query campaign by it's ID but I also use company ID(which is authenticated) to match and verify that the campaign belongs to the authorized company rather than just updating it. But I have to use

updateMany

instead of

update

because update does not support more than one argument in the where. I need to the updated object as the return value which is available in

update

which I can not use due to the above limitation. Is there a workaround for this? Thanks.

@Faizan 👋 The only workaround is to use 2 queries. One for verifying the company and then updating with

update

.

Thanks!

push

is used to add but that doesn’t check if it exists. In that case, you need 2 queries: to fetch the value first, add/remove items and then update with the latest value.

Alright. Thanks a lot for your quick reply! 😄