Here's the syntax for queries with composite key

    const deleteRelation = await prisma.labelplaylist.delete({
        where: {
            playlistId_labelId: {
                playlistId: playListIdVariable, //replace with appropriate variable
                labelId: labelIdVariable, //replace with appropriate variable
            },
        },
    });

You can read more in the get record by compound ID or compound unique identifier subsection of the CRUD Reference Guide in the Prisma docs. This reference shows reading data, but the where condition is similar for delete and update as well.

Here is the Prisma documentation to disconnect related fields

For single disconnect

const updatePost = await prisma.user.update({
  where: {
    id: 16,
  },
  data: {
    posts: {
      disconnect: [{ id: 12 }, { id: 19 }],
    },
  },
  select: {
    posts: true,
  },
})

To disconnect all

const updateUser = await prisma.user.update({
  where: {
    id: 16
  },
  data: {
    posts: {
      set: []
    }
  },
  include: {
    posts: true
  }
})

This post is the top search result for both implicit and explicit disconnect many to many. If you want to completely disconnect an implicit many to many:

const data = await prisma.group.update({
    where: {
        id: groupId,
    },
    data: {
        users: {
            set: [],
        },
    },
});

Gotten from here: https://github.com/prisma/prisma/issues/5946

I had a similar issue but with users deleting posts, this is how I deleted a post attached to a user via there id (in this case their sessionId)

await prisma.user.update({
    where: { sessionId: sessionId },
    data: {
        Post: {
            delete: {
                id: postId,
            },
        },
    },
});

in your case it will look something like this

await prisma.user.update({
    where: { id: userIdFromFunction },
    data: {
        Workspace: {
            delete: {
                id: workspaceIdFromFunction,
            },
        },
    },
});

Hope this helps!

Hey @taylorhlabs 👋

The issue here is explained in the error:

type ResourcesTagsWhereUniqueInput {
  resourceId_tagId?: ResourcesTagsResourceIdTagIdCompoundUniqueInput
}

You need to provide the arguments in the same way as follows:

 const result = await prisma.resourcesTags.delete({
    where: {
      resourceId_tagId: {
        resourceId: resourceId,
        tagId: tagId,
      },
    },
  })

If you press ctrl+space inside the where block in VSCode, you will the required suggestion :)