Standard Report Queries

For requests or help with our API
Post Reply
GatesKennedy
Posts: 2
Joined: Tue Nov 15, 2022 5:58 pm

Standard Report Queries

Post by GatesKennedy » Wed Nov 16, 2022 2:07 pm

Question:
Is there a way that I could view the SQL query running behind each of the Standard Reports presented in the OD Software or determine the corresponding query from the "Query List"?

References:
Query List - https://opendentalsoft.com:1943/ODQuery ... yList.aspx
Standard Reports - https://www.opendental.com/manual/reportsstandard.html

Thank you!

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Standard Report Queries

Post by SLeon » Wed Nov 16, 2022 2:49 pm

Good afternoon,

The Query Monitor is a great way to see the SQL queries running behind Open Dental actions, including reports. It is worth noting that sometimes multiple queries are used to produce a report and many will translate the information into a human-readable format prior to display.

GatesKennedy
Posts: 2
Joined: Tue Nov 15, 2022 5:58 pm

Re: Standard Report Queries

Post by GatesKennedy » Thu Nov 17, 2022 9:36 am

@SLeon This is very helpful! Thank you.

Post Reply