Notifications
Clear all
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
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
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
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
