If you have added Conditions and later wish to remove them, download the file from the following link and extract it on the server machine:
https://dl.waspbarcode.com/wasp/SupportFiles/DeleteConditions.zip
To remove all conditions other than the 4 default (New, Excellent, Good, and Bad) run DeleteConditions.bat without modification.
If you have entered several other conditions that you wish to keep and only need to remove 1, edit the line:
update condition set record_status = 2 where description not in ('New', 'Excellent', 'Good', 'Bad')
Change the bolded part of the line to:
where description = 'ERROR'
Replace ERROR with the condition you need to remove, leaving it in single quotes '.