Home User Manual Discussion Forum Search

Custom Queries

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 the Database Documentation section of the Programming Resources page. 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.
If you need clarification, see the Query Request Example below or contact support.

Practice Title or Doctor's Name

Individual Making the Request

Practice Phone Number associated with Open Dental account

Contact Phone Number

Email Address

Verify Email Address

What version of Open Dental are you currently using? (In Open Dental, click Help, About or Help, Update)

Describe the query:

What is the goal of the query? How will you use it?

Do you want to base the query on an existing query? Yes/No  
If yes, email the query to service@opendental.com or if a query example, enter the query number here.

What columns of data do you want and in what order(left to right)?
Include any descriptions or calculations.

What variables do you want to be able to change?

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.

Query Request Example

Below is an example of a request and the resulting query.

Note: If you do not know how to answer a question, enter the information you do know and we will contact you for more information.

Describe the query: 
A list of patients that have specific procedure code(s) completed in a date range. Also include their referral source if they have one. 

What is the goal of the query? How will you use it?  
To track and analyze which referral sources are sending us business and for which procedures. 

What columns of data do you want and in what order (from left to right)? 
1. Patient Name (Last Name, First Name) 
2. Procedure Code  
3. Date of Service  
4. Referral Source (just last name field)  

What variables do you want to be able to change? 
Date range and the provider: Date range, Procedure Code list (D0150, D0140)

The results of this query would look like this: 
Query Request Results

Open Dental Software 1-503-363-5432