Notifications
Clear all
Topic starter
Hello,
I am looking for some help pulling patient email addresses for a provider. I see that there are no canned reports for this. Maybe a SQL script? Any help would be appreciated. Thanks!
Posted : July 12, 2018 1:35 am
select pp.EMailAddress from PatientProfile pp
join DoctorFacility df on pp.DoctorId = df.DoctorFacilityId
where df.ListName like '%DRNAME%' and pp.EMailAddress like '%_@__%.__%'
Has very very basic email validation in it.
DRNAME could just be the last name or you could get very specific and match df.First and df.Last.
-TW
Posted : July 12, 2018 1:50 am
