Running a SQL command help

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
PeteNicholson
Posts: 5
Joined: Sat Aug 01, 2020 7:29 pm

Running a SQL command help

Post by PeteNicholson » Thu May 20, 2021 4:06 pm

Dear Forum,

Would someone be so kind as to assist me running a SQL command.

I wish to generate a report for a provider showing total production, total collection, list of all write offs (both insurance and from patients with the amounts), list of outstanding collections detailing whether it is insurance or other.

Your assistance would be greatly appreciated.

Cheers,

Peter

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Running a SQL command help

Post by joes » Tue May 25, 2021 9:05 am

Hello Peter, our Support Technicians can assist you with searching our existing reports and example queries. We also have a Query Team that can write a custom query if an existing one does not suite your needs. Please call 503-363-5432 to get in touch with a Support Technician, or see our website for other ways to contact support, https://opendental.com/contact.html. Below are links to our query examples page and our query request form.

Query Examples: https://opendentalsoft.com:1943/ODQuery ... yList.aspx
Query Request Form: https://opendentalsoft.com:1943/ODQuery ... tForm.aspx
Joe Sullivan
Open Dental Software
http://www.opendental.com

Post Reply