Notifications
Clear all
Topic starter
Anyone have a query or a report built that will pull all active ORDERSETS from CPS?
Thanks
Posted : April 6, 2017 2:49 am
Topic starter
Bump
Posted : April 11, 2017 2:36 am
This will pull all the names of your Order Sets:
select * from customorders where ordersetid <> 0
The detail items for each custom list are in the same table. A detail item's GID value will match the Order Set name's ORDERSETID
Should be the same for CPS and EMR.
Posted : May 12, 2017 3:50 am
Try this - it should give you the order set name and the detail:
select o1.ordertype, o.description,o1.description,o1.code from customorders o, qpicks q, customorders o1
where o.gid = q.qpid and o1.gid = o.ordersetid order by o.description, o1.description
Posted : May 12, 2017 5:07 am
