Open Dental Forum

We can search by last name, first name , city state etc

Is there any way of searching via email?

We send out a whole stack of emails, and some bounce because of wrong addresses, and it would be nice to be able to search via email

I'm using the newest beta version and it's an option in this version. I can't remember if it was there before or not.

Until then, here's a user query you can use. Just change the gmail.com part to at least part of the email. Leave the % symbols there.

SELECT * FROM patient
WHERE Email LIKE '%@gmail.com%';

Yeah you probably just need to update your version of Open Dental. I added this back in June of 2012.
http://www.opendental.com/manual/patientselect.html
(The last search filter on the screenshot)