looking at past RX
Posted: Tue May 08, 2012 6:01 am
Is there a way we can look at all the prescriptions we have printed in open dental for the past two months? If so, can you provide instructions on how to do so.
Hey drpeteryee. You going to need to run a custom query. I looked at the OpenDental examples http://70.90.133.65:1942/ODQueryList/QueryList.aspx and found this query #278, that I was able to edit for your needs.
/*278 Pull patients with prescriptions for a specific drug in given Date range*/
SET @FromDate='2009-01-01' , @ToDate='2009-12-31';
SELECT PatNum, RxDate, Drug, Disp, Refills, ProvNum FROM rxpat
WHERE drug LIKE ('%Amoxicillin%') AND
RxDate BETWEEN @FromDate AND @ToDate;
I edited the query to no search for specific drugs and that give you all Rx for a given date range.
/*278Modified Pull patients with prescriptions for in a given Date range*/
SET @FromDate='2009-01-01' , @ToDate='2009-12-31';
SELECT PatNum, RxDate, Drug, Disp, Refills, ProvNum FROM rxpat
WHERE RxDate BETWEEN @FromDate AND @ToDate;
Look to this page for assistance on how to run a query. http://www.opendental.com/manual/queryoverview.html