Notifications
Clear all
Topic starter
Hello,
I am looking for sql script that will show All Referral Orders from the last year, we need the Order Date, Ordering Provider Name and Referral Order Description. Thanks!!
Posted : July 18, 2019 8:58 am
SELECT O.ORDERDATE,DF.ListName,O.DESCRIPTION
FROM ORDERS O
JOIN DoctorFacility DF ON DF.PVId = O.AUTHBYUSRID
WHERE ORDERTYPE = 'R'
AND ORDERDATE >= '7/1/2018'
AND XID = 1000000000000000000
Posted : July 18, 2019 9:15 am
