Page 1 of 1

Standard Report Queries

Posted: Wed Nov 16, 2022 2:07 pm
by GatesKennedy
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!

Re: Standard Report Queries

Posted: Wed Nov 16, 2022 2:49 pm
by SLeon
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.

Re: Standard Report Queries

Posted: Thu Nov 17, 2022 9:36 am
by GatesKennedy
@SLeon This is very helpful! Thank you.