Notifications
Clear all
Topic starter
Does anyone know if it's possible to move a whole category of orders from "Service" to "Test and Procedures" without having to reenter all of the information. Thank!
Posted : September 22, 2017 3:58 am
Yes, but needs to be done through the database using a script
Posted : September 22, 2017 4:06 am
Topic starter
Thanks! Any idea on what that might look like?
Posted : September 22, 2017 4:11 am
Well it all depends on if you already have the codes setup in the right places.
Use this script to see what you will affect first:
SELECT *
FROM ORDERS
WHERE ORDERTYPE = 'S' --Order Type is a Service
AND CODE = 'CODEHERE' -- Input your orginial code here
AND CHANGE IN (2,6) -- Use this to only apply to open and active orders
AND ORDERDATE BETWEEN '1/1/2016' AND '12/31/2016' -- Use this if you want to do a date range only
Once you see that this is what you want to change, then do an update like this, again, this will all depend on what you want to change it to
UPDATE ORDERS
SET ORDERTYPE = 'T', --Changes Type to Test
CODE = 'NEWCODEHERE' --Input New Code to Change to here if different, if not, then do not use this part and remove the comma after the 'T'
WHERE ORDERTYPE = 'S' --Order Type is a Service
AND CODE = 'CODEHERE' -- Input your orginial code here
AND CHANGE IN (2,6) -- Use this to only apply to open and active orders
AND ORDERDATE BETWEEN '1/1/2016' AND '12/31/2016' -- Use this if you want to do a date range only
Posted : September 22, 2017 4:25 am
There is also a Clinical Kit builder that would allow you to export your service orders to an excel spreadsheet, modify, and re-import as Tests or referrals. I have attached the builder below.
Posted : September 22, 2017 4:36 am
Topic starter
That did exactly what I needed. Thank you Amanda!
Posted : September 22, 2017 6:17 am
