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