Notifications
Clear all
Topic starter
Orders Custom Lists, including Order Sets.rpt
A simple report, but it shows the Codes within the Order Sets (that reside within the Custom Lists)...
Posted : April 20, 2012 1:39 am
Hi, Please help, I need to get medication custom lists set up and users have medication custom lists set on their preferences. I just don't know what table to pull.
Thanks,
Sa
Posted : May 23, 2014 4:26 am
Try this - EMR 9.5/Oracle sql query:
select u.firstname, u.lastname, u.status, 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 = 'MedCustomList' and status = 'O' order by q.description --User Med Custom Lists
Posted : May 27, 2014 12:13 am
I tried to link in Crystal reports but the type of variable in Pref.prevalue is string and the type of qpick.qpid is integer, therefore I can't link these tables. Any other suggestions?We are on CPS11 and it uses SQL database not Oracle anymore.
Thanks for your reply.
Sa
Posted : May 27, 2014 12:49 am
