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

Removing Problem Custom Lists

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

76 Views

RSS

rfisher

(@rfisher)

Posts: 126

Estimable Member

Topic starter

I want to remove a Problem Custom List but get a pop-up saying there are users that use this list as their preference.

How do I find the users? Is there a SQL script I can run to find them?

Posted : May 22, 2015 5:22 am

dduschel

(@dduschel)

Posts: 207

Reputable Member

We would be interested in this as well. We changed the name of the custom list saying they need to call "phone number here" but they didn't call. Provider hasn't been here in years so we figure it was a nurse before our time who has been obsoleted who still has it set.

Posted : May 22, 2015 5:39 am

jsander

(@jsander)

Posts: 108

Estimable Member

I found where the preferernce is set, but not which values go with which lists. You could set your own preference to the offending list and see who matches it. Then it looks like you might have to reinstate the user to set that preference.

SELECT PREF.PREFNAME, PREF.PREFVALUE, USR.LOGINNAME
FROM PREF INNER JOIN
USR ON PREF.DoctorFacilityId = USR.doctorfacilityid
WHERE (PREF.PREFNAME = 'probcustomlist')

Posted : May 22, 2015 7:06 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

You could always do a global reassignment of the custom list. Globally setting it to another list just to remove that one... its not a clean answer as it would annoy people who wouldn't use the list they were reassigned to but they might make the call to the help desk, but it would work.

Posted : May 26, 2015 3:53 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I am not sure if this will help or not but the problem custom lists are located in the table "QPICK" and the individual entries are located in "ICDDEPT"

EDIT: I took out the part about the pref table from this comment as I realized it was not correct.

Posted : May 26, 2015 12:14 pm

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

This is a quick query I wrote for CEMR (oracle) but I think it should be the same or at least similar:

select qpicks.description, usrinfo.searchname, usrgroup.groupname from pref inner join qpicks on qpicks.qpid = pref.prefvalue left outer join usrinfo on usrinfo.pvid = pref.groupid left outer join USRGROUP on USRGROUP.GID = pref.groupid where pref.prefname like 'ProbCustomList' order by description, searchname, groupname

You should get a list of the Problems Custom Lists followed by either the user or group that it is assigned to. (one or the other)

Posted : May 26, 2015 12:27 pm

Share:

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