Open Dental can modify a Query or write a custom query for customers currently on support.
Due to the overwhelming demand for custom queries, we currently have a backlog of requests. Thus it may take several weeks to process and write a custom query. Another option is to instead hire a third-party query writer or develop an in-house query writing service. To see Open Dental's database schema see Database Documentation. The Query Examples may also be helpful, as well as the Open Dental Discussion Forum.
Only delivered queries incur a charge. There is no charge to submit a request.
Query Request Form
Please fill out each section carefully.
You should receive an automatic response via email within a few minutes. If we need additional details, we may follow up via email or phone. After processing the request, we will send another email with the query request number for reference. Once we have a quote for how much the query will cost, we will contact you.
Below is an example of a request and the resulting query.
Describe the query:
What is the goal of the query? How will you use it?
What columns of data do you want and in what order (from left to right)?
What variables do you want to be able to change?
The results of this query would look like this:
Open Dental Software 1-503-363-5432