Open Dental Forum

Previous dentist on EasyDental had hundreds of different communications to the patient while trying to send out a mass mailing. Because of this each account in opendental now has dozens of commlogs that are useless.

Will I break anything by running a sql query to delete rows from the commlog table? I ran the following query on the following on a backup copy of the database.

delete from commlog where Note='retirement letter.doc'

So far it has not seemed to have broken anything, but I just want to make sure there are no table linkages that would break...

You should be ok this one time, but please don't get in the habit of running such queries. Eventually, something is bound to break.

100% agreed. I was uncomfortable with the idea which is the reason for the post. However the 20 + lines of red throughout the progress notes is really annoying. I will backup the database before running the query and obviously won't mess with the database in the future.

I guess I should have been more relaxed about it. If it's considered part of a conversion script that was tested ahead of time, it's much more acceptable. And if it's cleanup after a conversion it's also much more acceptable.