Selecting pt via email

[aussiedentist]

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

[KevinRossen]

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%';

[jsalmon]

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)