Open Dental Forum

Is it possible to DELETE EVERY BROKEN APPOINTMENT I ever made for a provider, or the entire practice?

Reason, i need to export all appointments, but the broken ones are also exported!!

happy if there is another solution!

ps i have closed the surgery, so it the db doesnt really matter

Hi,

your question is broad. I assume you want to extract all appointments for a single provider without the broken appointments. You could

- Use the standard reports under "lists" to export both the appointments and the broken appointments, export them to excel and substract
- Use your own SQL Query (ask OD for support)
- Use the API (external software)

However, to answer the literal question: There seems to be no method to "delete" broken appointments from the OD Database automatically or by program (https://www.opendental.com/site/apiappointments.html, maybe I am wrong).

Joerg