if i got a prisma field like this:

roleIds: String[]

How can I delete 1 value from many users?

await prisma.serverMember.updateMany({where: {roleIds: {has: roleId}}, data: {
  roleIds: // what goes here?
}});

Hi @Fishie 👋 There's no method to splice/remove items from a scalar list using Prisma. You would have to fetch the scalar list from your database, modify it manually in your application code and overwrite the record in your database with an

update

operation. There is a feature request for this, please feel free to follow/comment with your use-case to help us track demand for this feature.

Yikes, why does prisma have so many lacking features

Did you have a chance to look at this

UPDATE table_name 
SET column_name=(array_remove(column, 'keyword to be removed')) 
WHERE 'keyword to be removed' = ANY(column_name);

and how do i run that in js?

You would need to use Prisma queryRaw

ty

You're welcome.