Notifications
Clear all
Topic starter
I am trying to come up with a query to trace an email address back to a patient. We went live with our portal and it has been anything but smooth so I have several email addresses which I would like to get more info about to see which patient belongs to the address.
I have tried several variations of-
select * from patientprofile where emailaddress like '%[email protected]%'
select * FROM dbo.PatientProfile where EMailAddress.PatientProfile is '[email protected]'
This is really my first attempt of doing something like this and there do not seem to be any reports which will help me match email addresses to patients
I am using CPS 10, BTW
Mike Zavolas
Tallahassee Neurological Clinic
Posted : September 11, 2012 5:54 am
The first one should work. I just used it in my system to look for @verizon.net address and it pulled back 1200+.
If you have the full address, it should pull up the patient that if matches if it was entered correctly in Registration. Where are you getting the email addresses from?
Posted : September 11, 2012 7:46 am
Topic starter
ErnieT said:
The first one should work. I just used it in my system to look for @verizon.net address and it pulled back 1200+.
If you have the full address, it should pull up the patient that if matches if it was entered correctly in Registration. Where are you getting the email addresses from?
Well, crap. I was hitting the 'debug' button instead of 'execute'.
I found a log file called CCportal in /program files/Kryptiq corporation/cc/log which has patient addresses in there, seemingly when an error occurs and prevents them from doing portal things.
Thanks for the reassurance on the script. In my defense, it was late 🙂
Posted : September 12, 2012 7:55 am
