I want to update based on the combination of keys which are unique in my DB. When I update based on primary key it works but not on combination of keys which are defined unique. await this.service.update({ where:{ platformApplicationIdentity: uiData.platformApplicationIdentity, settingType: uiData.settingType, identity: uiData.identity, user: uiData.user, }, data:{ lastTouchedBy: uiData.lastTouchedBy, summary: uiData.summary, lastTouchedTimeUTC: uiData.lastTouchedTimeUTC == undefined ? null : uiData.lastTouchedTimeUTC, lastTouchedComment: uiData.lastTouchedComment == undefined ? null : uiData.lastTouchedComment, tenant: uiData.tenant == undefined ? null : uiData.tenant, } })

Could you share your schema?

model UISettingSummary { platformApplicationIdentity String settingType String identity String user String? id Int @id @default(autoincrement()) lastTouchedBy String lastTouchedTimeUTC String? lastTouchedComment String? summary String tenant String? PlatformApp PlatformApplication @relation(fields: [platformApplicationIdentity], references: [identity]) @@unique([settingType,identity,platformApplicationIdentity,user], name: "UniqueKeys") }

The

where

would include the unique name for the fields:

where:{
  UniqueKeys: {
            platformApplicationIdentity: uiData.platformApplicationIdentity,
            settingType: uiData.settingType,
            identity: uiData.identity,
            user: uiData.user,
  }
},

where: { UniqueKeys: [ uiData.settingType, uiData.identity, uiData.platformApplicationIdentity, uiData.user ], }, I changed it to this , but the code editor still shows error

It’s not an array. It’s an object

{}

.

ok