Delete Survey records

[johnrob18]

I have cloned an environment and now want to clear down all the records not required.

I have 26,000 surveys on the system in various states that I would like to delete.

I have tried to clear down the records on the tables (in Tables & Columns) but none of these has deleted the records.

When I try to delete the records manually I get the following error message.

Any thoughts how I can clear down these records?

[arielgritti]

Hello

It's look there is a Referential integrity Constraint with the "Assessment Instance Question" table (asmt_assessment_instance_question).

Try deleting records from asmt_assessment_instance_question before.

Be careful about the "deletes".

Please, mark my answer correct, useful or bookmark if I helped you

Thanks

Ariel

[snowolper]

Yea I used the above to help me. 

Searched: asmt_assessment_instance_question.list

Cross-referenced the instances that I needed to clean up one by one, deleting them, and then deleting the referenced assessment_instance.

Its pretty painful... This needs to be fixed...