See Database Management Systems.

Open Dental can modify an existing Query Example or previous query request or write a custom query for customers currently on support.

Frequently Asked Questions

When will I be charged?

The charge is applied once the query has been written and delivered. We will not proceed with writing the request until we have received explicit, written approval of the estimated cost.

Can I get a custom query if I'm not on support?

No, you must be on support for the duration of the query request process.

What does expediting do?

Expedited processing ensures the query is the first in line for processing. We cannot guarantee we will be able to meet any given deadline, and deadlines that are less than a month out are extremely unlikely to be met. We strongly recommend expediting the query request if you have a deadline to meet, and submitting the request as soon as you know what the deadline is to ensure delivery is as close to the deadline as possible.

Is there a charge for changing the query?

This depends on the complexity of the requested changes. We will need to call you to thoroughly discuss these changes, then provide a new cost estimate.

I updated Open Dental and now my query doesn't work. Can you fix it?

Sometimes our engineers make changes to the code that defines how data is organized in the database that cause older queries to no longer run. Since queries are written specifically for the version you are on at the time of the request, a new request is needed to write the query for a different version.

How do I cancel my request?

Call our support line or email the Query Team at queries@opendental.com. Make sure to reference the number of the request you wish to cancel. Please note that queries cannot be cancelled once the writing process has begun.

Can I reopen a cancelled request?

Yes! Call our support line or email the Query Team at queries@opendental.com. Make sure to reference the number of the request you wish to reopen.

I have a query that wasn't written by Open Dental. Can you help me with it?

No. We cannot modify queries that were written outside of our organization.

Other issues or questions?

For all other issues, please call our support line or send an email to the Query Team at queries@opendental.com.

Submitting a Query Request

To get started, fill out a Custom Query Request Form.

Due to the overwhelming demand for custom queries, we currently have a backlog of requests. It may take several weeks to process and write a custom query. More complex queries may be split into multiple queries, or in some cases, denied.

If you need a request sooner, or the request was denied, consider alternate options:

• Review existing Query Examples.
• Hire a third-party query writer or develop an in-house query writing service. See Programming Resources.
• Reach out to other users for advice on the Forum.
• Reach out to other users for advice on the Facebook User Group.