Query for free time by provider

For users or potential users.
Post Reply
Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Query for free time by provider

Post by Tom Zaccaria » Wed Oct 21, 2015 2:55 am

Need a query that returns free time (time units) for a provider over length of time.
For example, Doc A works three 8 hour days a week. That is 24 total hours. We us 15 minute intervals so that would be 96 time units total.
I want to find the number of time units that were free as in cancelled or broken or never scheduled.

If you can direct me to something that is already written and needs modification that would be a plus.
Thanks,
drtmz

User avatar
Jandrew
Posts: 17
Joined: Thu Jun 11, 2015 2:45 pm

Re: Query for free time by provider

Post by Jandrew » Wed Oct 28, 2015 8:52 am

Hello Doctor,
Unfortunately, I don't see anything that exactly matches your needs on our website. If you're interested in requesting a custom query, please do so here and we'll contact you with any questions.
Programmer (n.): A machine that turns coffee into code.

Andrew Jansen
Open Dental Software
Software Engineer
andrew@opendental.com
503-363-5432

Post Reply