DB Export of QueryList Examples

This forum is for programmers who have questions about the source code.

DB Export of QueryList Examples

Postby 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
ajhalls
 
Posts: 23
Joined: Fri Jan 10, 2014 2:41 pm
Location: Utah

Re: DB Export of QueryList Examples

Postby 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
cmcgehee
 
Posts: 602
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: DB Export of QueryList Examples

Postby 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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

Re: DB Export of QueryList Examples

Postby 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
ajhalls
 
Posts: 23
Joined: Fri Jan 10, 2014 2:41 pm
Location: Utah


Return to Developers

Who is online

Users browsing this forum: No registered users and 5 guests