Notifications
Clear all
Topic starter
Please help to see who set problem custom lists under their preferences. We wanted to remove few problem custom lists but couldn't because they were set under user's preferences.
Thanks,
Sa
Posted : March 6, 2014 3:33 am
select u.firstname, u.lastname, p1.prefname,q.description from ml.pref p1, ml.usrinfo u, ml.qpicks q where p1.groupid = u.pvid and p1.prefvalue = q.qpid and p1.prefname = 'ProbCustomList'
This will get you all users. You can't delete something like this if inactive users have it set as a preference. This is just a sql query (written for EMR) and not Crystal but your Crystal developer may be able to get it from the sql query.
Posted : March 10, 2014 7:58 am
