I am trying to create a multi-select delete documents query for a MongoDB database using checkboxes in a table. However, my current query only works for a single row. I need help with creating a query that can delete multiple rows at once.
The goal was to create a multi-select delete query for a MongoDB database in Appsmith. The checkbox was added to a table, connected to a simple get documents query. The Appsmith syntax was unknown for deleting multiple rows. Initially, the
selectedRow._id syntax was used to delete a single row, but that didn't work for multiple rows.
The first query that was tried using
Table1.selectedRowIndices only worked for a single row. The second query that was tried using
Table1.selectedRows and the
map function showed only one
_id instead of an array of them.
Finally, a solution was reached using a modified version of the second query. The modified query used the
map function along with
ObjectId() to convert the
_ids to the
ObjectId format that MongoDB requires. This query was able to delete multiple rows.
In summary, the solution involved using the
map function to convert the
_ids to the
ObjectId format, and then using
$in to match the resulting array of
ObjectIds in the delete query.