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 »

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
User avatar
jsalmon
Posts: 1609
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: queries

Post by jsalmon »

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
Ralph McElmurry
Posts: 32
Joined: Mon Jun 18, 2007 5:49 pm

Re: queries

Post by Ralph McElmurry »

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