queries

For users or potential users.
Post Reply
Ralph McElmurry
Posts: 32
Joined: Mon Jun 18, 2007 5:49 pm

queries

Post by Ralph McElmurry » Thu Feb 13, 2014 2:08 pm

Is it possible to see the source code of the sql queries on the standard report screen? I'd like to modify some of them as user queries.
Ralph McElmurry, DDS, MS
Top
User avatar
jsalmon
Posts: 1569
Joined: Tue Nov 30, 2010 12:33 pm
Contact:
Contact jsalmon

Re: queries

Post by jsalmon » Thu Feb 13, 2014 5:19 pm

Most reports are generated dynamically with C# and aren't really cut and paste into SQL queries (otherwise we'd probably just post those to our query examples page). We've written lots of queries that are as close as possible to the reports and modules and post them to the public. I'd recommend checking those out first: http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

If you really want to see the source code, dive right in! http://www.opendental.com/manual/sourcecode.html

If you go the source code way, the "standard report" screen you are referring to (I'm guessing) is FormReportsMore.cs
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com
Top
Ralph McElmurry
Posts: 32
Joined: Mon Jun 18, 2007 5:49 pm

Re: queries

Post by Ralph McElmurry » Mon Feb 17, 2014 9:23 am

OK, thanks, Jason.
Ralph McElmurry, DDS, MS
Top
Post Reply

Return to “Main Forum”