Page 1 of 1

Table instemplate

Posted: Wed Feb 28, 2024 10:15 pm
by Hersheydmd
One of the Queries at the bottom of the User Query Favorites window is "Table - Insurance Template" .
When I run it I get "Invalid query: Table 'opendental.instemplate' doesn't exist."
What is that table supposed to return?

Re: Table instemplate

Posted: Thu Feb 29, 2024 8:35 am
by allends
Query favorites are just SQL queries that have been saved for later.
https://www.opendental.com/manual233/qu ... rites.html

The InsTemplate table does not exist in the Open Dental schema, so the most likely source of that User Query Favorite is a 3rd party.