DB Export of QueryList Examples

This forum is for programmers who have questions about the source code.
Post Reply
ajhalls
Posts: 36
Joined: Fri Jan 10, 2014 1:41 pm
Location: Utah
Contact:

DB Export of QueryList Examples

Post by ajhalls » Mon May 13, 2019 10:25 am

Any chance of getting a SQL / CSV dump of the table used to build this page?
https://opendentalsoft.com:1943/ODQuery ... yList.aspx

I would like to incorporate some of these queries into my software and while I can get them all by going into each category, there then ends up over 6000 because a query may be tagged in multiple categories.
Dr. Alan Halls DMD
alan@reminderdental.com
ReminderDental.com - A new way to save

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: DB Export of QueryList Examples

Post by cmcgehee » Mon May 13, 2019 12:55 pm

We do not have a way to distribute this list as a dump file.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: DB Export of QueryList Examples

Post by jsalmon » Mon May 13, 2019 2:03 pm

The main page that loads (with no filters) should be every query that we have available (hence it takes so long to load). I have not verified this information recently so it might be wrong but was true back in the day (8 years ago).
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

ajhalls
Posts: 36
Joined: Fri Jan 10, 2014 1:41 pm
Location: Utah
Contact:

Re: DB Export of QueryList Examples

Post by ajhalls » Mon May 13, 2019 8:33 pm

Here is the data formatted for insert into a table. I am still working out the tags. Data order is (ID, Description, Warnings, Query Body)
https://ufile.io/etmc2vln

At some point I think it would be nice to have a preview of the output of each query so people can quickly see whether it is what they are looking for.
Dr. Alan Halls DMD
alan@reminderdental.com
ReminderDental.com - A new way to save

Post Reply