Page 1 of 1

DB Export of QueryList Examples

Posted: Mon May 13, 2019 10:25 am
by ajhalls
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.

Re: DB Export of QueryList Examples

Posted: Mon May 13, 2019 12:55 pm
by cmcgehee
We do not have a way to distribute this list as a dump file.

Re: DB Export of QueryList Examples

Posted: Mon May 13, 2019 2:03 pm
by jsalmon
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).

Re: DB Export of QueryList Examples

Posted: Mon May 13, 2019 8:33 pm
by ajhalls
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.