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
Is it possible to DELETE EVERY BROKEN APPOINTMENT for the practice?
-
AussieDentistThird
- Posts: 11
- Joined: Tue Dec 20, 2022 7:07 pm
-
joergzastrau
- Posts: 39
- Joined: Sun Feb 27, 2022 2:53 am
Re: Is it possible to DELETE EVERY BROKEN APPOINTMENT for the practice?
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
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