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

Pop-up Question

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

73 Views

RSS

mdiventi

(@mdiventi)

Posts: 54

Trusted Member

Topic starter

Hello! Is there a way to wipe out all pop-ups in patient charts to start from scratch?

Thank you!

Posted : May 17, 2018 2:46 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

First let me say that removing all Pop-Ups from a patient(s) chart can be dangerous if you are not adept with SQL. So you need to be well versed in SQL to make modifications to the script I am about to post, otherwise you could remove all Pop-Ups and Alerts on all patients.

You will probably want something like:

delete f
from FLAG f
where f.CONTEXTID1 = {Patient PID}
and f.POPUP = 1
and f.TYPE = 1 -- Type 0 is for Flags, Type 1 is for Alerts or you could leave this off for both

Posted : May 17, 2018 4:30 am

jennifertyson

(@jennifertyson)

Posts: 26

Eminent Member

We have a few charts with old pop-ups and we cannot remove them. the remove feature is grayed out. Is there another way to remove them or is there a sql script that can be ran to remove specific pop-ups? In some cases we have more than one pop up but only need to remove 1 of them. Thank you for any help.

Posted : September 14, 2018 9:30 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

You should be able to use the Patient PID against the Flag table to determine which flags belong to a certain patient. You can then look at the Message in that Flag record to make sure that it is the one you are looking for and then delete that specific Flag record based on the ID field.

If you are well versed in SQL then you should be able to understand what I just explained. If you, however, do not know how to do what I explained above then I highly recommend that you do not attempt to use SQL to delete anything from the database, not even from the Flag table. Without knowing what you are doing you run the risk of corrupting the data in your database and/or losing it altogether.

Posted : September 17, 2018 4:12 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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