Notifications
Clear all
Topic starter
I am looking for a report I can run to list patients of a certain provider that will also include the patients email address. Can anyone help with this?
Posted : May 28, 2015 3:38 am
i can provide you with a script so you can run to get your data. Let me know if that will work for you. or if you send me your Crystal report that you are running now, i can modify it to show that field for you.
Posted : May 28, 2015 5:56 am
How would you like to associate the provider to the patient? Is it the responsible provider in registration? Or some other logic? This would be easy to put together.
Posted : May 28, 2015 9:07 am
Here is a SQL script you could use:
SELECT P.PatientId, P.First, P.Last, P.EMailAddress
FROM PatientProfile P
INNER JOIN DoctorFacility MD ON P.DoctorId = MD.DoctorFacilityId
WHERE MD.LoginUser = 'ENTER USERNAME HERE'
Posted : May 28, 2015 10:26 am
