what are the different ways to delete multiple records of a table at once with out script

[Kevin68]

what are the different ways to delete multiple records of a table at once with out script

[Sebas Di Loreto]

@Kevin68 

This is an example when I had to delete multiple records on the awa_work_item table

var awa = new GlideRecord('awa_work_item');
awa.addEncodedQuery('document_table=incident');
awa.setLimit(40000);
awa.deleteMultiple();

[Kevin68]

without script? how can we delete?

[Sebas Di Loreto]

@Kevin68 

My bad... I didn't pay attention to the "without script" 😉

You can delete without a script but you are limited to chunks of 100

You select all 100 records on the page and then click on delete. Once that is done, you select the next 100 and keep going. It is fine for small amounts but if I have to delete 4000 I would be doing this 40 times... not fun!

[Kevin68]

but there is a thing I forgot we can delete all 1000 records at one go but it will take time.

i couldn't recall it.