I am creating a website that shows errors of features and errors that have been resolved (fixed). I want to use datareviewer to find this errors. The errors are stored in a MS SQL database. The problem I have is that when errors are fixed, the data reviewer does not automatically remove errors that have been fixed within the database table.
I was hoping someone can inform me on whether there is a way to remove errors that have been fixed from the database when datareviewer runs, after the errors have been fixed. The only way I can do so is by removing all records in the database table before datareviewer, but I want to avoid that, because error records that I marked as exceptions will also be removed.