Table instemplate

For users or potential users.
Post Reply
User avatar
Hersheydmd
Posts: 700
Joined: Sun May 03, 2009 9:12 pm

Table instemplate

Post by Hersheydmd » Wed Feb 28, 2024 10:15 pm

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?
Robert M Hersh DMD, FAGD
Univ. of Penn 1982
Brooklyn, NY 11234
https://www.facebook.com/pages/Robert-M ... 1471599429

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Table instemplate

Post by allends » Thu Feb 29, 2024 8:35 am

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.
Allen
Open Dental Software
http://www.opendental.com

Post Reply