Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

SQL Query for a newbie

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

61 Views

RSS

tnc

(@tnc)

Posts: 517

Honorable Member

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

ErnieT

(@erniet)

Posts: 479

Honorable Member

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

tnc

(@tnc)

Posts: 517

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0