If you find a query you like, copy/paste the query into Open Dental to run it. Use the Help Featureto search "User Query" for more information. If needed, change any required variables before running. …

Custom Queries Open Dental can modify a query or write a custom query for customers currently on support. Many queries are already available on our Query Examples page. Please review existing …

Oct 7, 2008 · Can someone offer a query to find out how many deceased patients there are? I checked the query examples and can't seem to find anything that will give me these two reports.

Sep 18, 2007 · Query for Insurance and Employer by josiedds » Thu Jun 22, 2017 7:28 pm I'm looking to run a report that shows who the employers are for a particular insurance. For example, which …

Nov 23, 2011 · Query Examples by Rickliftig » Tue Nov 22, 2011 3:26 pm I am amazed at the number and types of query examples that exist for OD. Could they be sorted in a better way or listed as …

Oct 24, 2016 · Query for accounts with particular insurance carrier by jthuisman » Wed Sep 21, 2022 5:05 pm I am trying to create a list of active accounts which currently have a particular insurance carrier.

May 20, 2016 · Re: Query showing patients by specific provider? by jsalmon » Mon Aug 29, 2016 5:14 pm Out of our hundreds of query examples that we write for customers I'm fairly certain this query or …

Jan 23, 2012 · Is is possible to make the following query: I need to count how many encounters I had with patients in 2010 to 2011 with a specific type of insurance

Sep 26, 2016 · Adding p.Email for email list gets me real close, but I'd love to have the patient's Insurance name and benefits remaining. I don't think recall and patient tables have CarrierName …

May 3, 2008 · In any case this query relies on procedures performed on patients to determine when they came to the office, so if you didn't get that information transferred to OD, then I don't think this query …