Resetting ok to Text Field

For complex topics that regular users would not be interested in. For power users and database administrators.

Resetting ok to Text Field

Postby drtech » Fri Jul 20, 2018 6:08 am

I would like reset the "Text OK" field back to "??" for all patients who are currently marked "YES", but leave all the pts who are marked "NO" the same. We are revamping our permissions with better written authorizations, so I need everyone back to square one unless they already told us no texting. Can we get a simple query to do this?

Thanks
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: Resetting ok to Text Field

Postby jsalmon » Fri Jul 20, 2018 9:02 am

Open Dental doesn't give out queries that manipulate data. All data manipulation should be within the program for security purposes. Therefore a feature request would be required for a tool within the software to do it.
http://www.opendental.com/manual/featurerequests.html
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: Resetting ok to Text Field

Postby drtech » Fri Jul 20, 2018 11:54 am

ok, thanks, I will try to write one since I can't put in requests.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: Resetting ok to Text Field

Postby drtech » Thu Jul 26, 2018 8:58 am

it is simple if someone needs to do something like this:

************NOTICE, THIS WILL ALTER YOUR DATABASE*****************************

Text deleted by admin.
Reason:
Open Dental doesn't give out queries that manipulate data. All data manipulation should be within the program for security purposes.

*********************************************************************************************
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO


Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 5 guests