Bulk operations on tables with relations

Hi, if I try to perform a bulk delete on a table with relations, I get this:

`289 | if (((_b = response.headers.get("content-type")) == null ? void 0 : _b.includes("application/json")) || responseType === "arrayBuffer") {
290 | responseText = JSON.stringify(data);
291 | } else {
292 | responseText = data == null ? void 0 : data.message;
293 | }
294 | throw new AppwriteException(data == null ? void 0 : data.message, response.status, data == null ? void 0 : data.type, responseText);
^
AppwriteException: Bulk delete is not supported for tablesDB with relationship attributes
code: 400,
type: "general_bad_request",
response: "{"message":"Bulk delete is not supported for tablesDB with relationship attributes","code":400,"type":"general_bad_request","version":"1.8.0"}",

This is the code I am tryng to run

`const response = await tables.deleteRows({
databaseId: process.env.APPWRITE_DATABASE_ID!,
tableId: 'categories',
queries: [Query.equal('is_default', false)],
});

console.log(response);
`
Am i doing something wrong or is it the way it is supposed to work?

As per my knowledge, for this, you've two choices. One is that you can remove the relationship if it's not very important (which I know isn't a good choice). Second is that you can take help of loops in your code's logic (at least it's better than the first option and you can customize it too as per your needs).

It is that way indeed

Bulk operations are not allowed on rows with relationships as the docs say too.

Yes, it might be so because some relationships could be complicated that makes bulk operations harder to use and that’s why I suggested the above workarounds.

cc @user @user