How to clear out large portions of a webform results table, without clearing out the entire table? There are maybe 3000 legitimate entries covering several years, and 5000 bad entries (all on the same day). Would like to keep the good stuff and don't want to hit "delete" and then "OK" 5000 times for the bad stuff.

Comments

quicksketch’s picture

quicksketch
he/him
commented

You can do this easily enough with two simple SQL queries:

DELETE FROM webform_submissions WHERE sid > 3000 AND sid < 4000;
DELETE FROM webform_submitted_data WHERE sid > 3000 AND sid < 4000;

Replace "3000" and "4000" with the submission ID range you want to delete.

Assuming there aren't any files associated with the submissions, this shouldn't have any side effects.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.