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 »

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: 605
Joined: Mon Mar 01, 2021 10:00 am

Re: Standard Report Queries

Post 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.
GatesKennedy
Posts: 2
Joined: Tue Nov 15, 2022 5:58 pm

Re: Standard Report Queries

Post by GatesKennedy »

@SLeon This is very helpful! Thank you.
Post Reply