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

Looking for a query

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

90 Views

RSS

woodjh

(@woodjh)

Posts: 57

Estimable Member

Topic starter

Does anyone have a query that list all of the alert/flags (flags, care alert, popup alert) that are active? We have so many now that a lot of staff aren't really looking at them now. Most of which aren't meaningful anymore.

Second question
How do you keep a grip on staff creating alerts/flags?

Posted : March 27, 2018 11:53 pm

bhoover

(@bhoover)

Posts: 360

Honorable Member

If you just want to see all of the flags/care alerts etc. and you don't care about the context you can do this:

select *
from flag f
where f.status = '0'

You can then change the status value to show what you need.

0 = Unviewed
1 = Viewed
2 = On hold; saved

You are probably going to get more back than you want and will need to modify to limit by date, location or user as well.

Regarding your second question, we don't really have a policy on flags. I would be interested to hear what others have to say on that issue.

Posted : March 28, 2018 12:19 am

woodjh

(@woodjh)

Posts: 57

Estimable Member

Topic starter

Has anyone used a query statement to remove the flags? I noticed that was a delete date field in the table. In testing that is the date for the expired date in the screen when creating an alert.

Posted : March 28, 2018 2:38 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

We have "deleted" flags before, or rather just marked them as deleted in bulk. They are still in the flag table the users just don't see them in the application. Off the top of my head, I believe if you change flag.status to -1 it should do it.

Posted : March 29, 2018 12:59 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

I found this to get you started. In this case we had sent a bulk care alert for patients who needed a prevnar injection. In the care alert we asked that users remove it after giving the injection. However, sometimes they did not, so we wanted to delete the alerts where the patient has a prevnar present. So the script below looks for the message text sent, and patients where a prevnar was given. Hopefully this is helpful.

UPDATE FLAG
SET flag.STATUS = -1
WHERE flag.ID in (
SELECT ID FROM FLAG
LEFT JOIN Immunization imm ON flag.CONTEXTID1 = imm.PID
WHERE flag.MESSAGE LIKE '%Patient due for Prevnar 13. Remove care alert after giving.%' AND flag.CONTEXTID1 IS NOT NULL AND imm.VaccineGroupName = 'Pneumococcal PCV13' AND imm.WasGiven = 'Y')

Posted : March 30, 2018 2:52 am

Share:

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