[TYPO3-UG US] Typo3 tx-survey_results problem

[Montgomery, Matthew]

Good afternoon,

I have been working with the installer of our website that is in Typo3 and we have a few forms setup on there that use the form storage folders and questionnaire menu item.  My concern to the installer was that over time these submissions from our users will grow to be quite large and our admins that are exporting the form results are becoming very tired of the thousands of records to go through to filter out which ones they want.
It has been proposed that we purge the results every few months so we begin with no entries and have a much smaller number of records to work with.

The installer of the site said to simply go to the list view and remove the results for each form.  This is a very cumbersome process and continually ask myself, why would anyone do this? And there has to be a better way.  I have phpmyadmin installed on the web server and have direct access to the database and I have found the tx_survey_results table.  Why can I not just purge those results for all of our forms? We don't need to keep that data indefinitely once we export anyway.

I look forward to anyone's response on this, I am dying to get this resolve and to have a workable solution.

Thanks

Matthew T. Montgomery
Network & System Administrator
Wesley College
120 North State Street
Dover, DE 19901
United States