I have been struggling trying to get the syntax right. I want to clear out a table called ListOfItems If I do

// Delete all rows from the ListOfItems
await ListOfItems.deleteRecords([])

It says I must set deleteAllRows to true.... How do I do this? If I try something like this it also complains....

await ListOfItems.deleteRecords({
  ids: [],
  deleteAllRows: true
})

Silly issue but hope some one can give me a clue... Thanks

Hi ! here is an example of code that works 🙂

async function deleteAllRecords() {
  try {
    const data = await messagesTable.findRecords({ filter: AI`Everything` })

    if (!Array.isArray(data)) {
      console.log('No records found.')
      return
    }

    const recordIDs = data.map((record) => record.id)

    if (recordIDs.length > 0) {
      await messagesTable.deleteRecords(recordIDs)
      console.log('Old records deleted.')
    } else {
      console.log('No records to delete.')
    }
  } catch (error) {
    console.log(error)
  }
}

await deleteAllRecords()

Thanks OOOBo, quite a script just to drop all rows when the documentation https://botpress.com/docs/cloud/studio/tables/#delete-records-from-a-table I get the idea it should just be a one or two line command?

in fact, if you look closely, there are only 3 lines 😉

Cool Thanks OOObe This did the trick for me,

const data = await ListOfItemsTable.findRecords({})
const recordIDs = data.map((record) => record.id)
await ListOfItemsTable.deleteRecords(recordIDs)

still think the doc is wrong though....

Okay thanks for the update 👍