Is there a way to look at all the patient's recall at once?
I want something similar to when selecting a tooth and looking at the entire history by using the show button.
Recall History
Re: Recall History
There isn't a feature in the program that allows you to do this. I found a query on our Query Examples page that displays all recall appointments. If you like, I can modify it so that it displays for just one patient.
Code: Select all
/*525 All recall appointments in date range with status.*/
SET @FromDate='2015-01-01' , @ToDate='2016-12-21'; /*set dates here, includes these and all between*/
SELECT p.FName,
p.LName,
p.WirelessPhone,
p.HmPhone,
p.WkPhone,
a.AptDateTime,
a.AptStatus,
MIN(r.DateDue) AS DateDue,
rty.Description
FROM appointment a
INNER JOIN patient p ON a.PatNum=p.PatNum
INNER JOIN recall r ON r.PatNum=p.PatNum
INNER JOIN recalltype rty ON rty.RecallTypeNum=r.RecallTypeNum
INNER JOIN recalltrigger rtr ON rtr.RecallTypeNum=r.RecallTypeNum
INNER JOIN procedurelog pl ON pl.CodeNum=rtr.CodeNum
AND pl.ProcStatus IN(1,2) /*TP or Completed proc*/
AND pl.AptNum=a.AptNum
WHERE a.AptDateTime BETWEEN @FromDate AND @ToDate+INTERVAL 1 DAY
GROUP BY a.AptNum
ORDER BY a.AptDateTime
Re: Recall History
That or running the Daily Procedures Report and adding a proc filter for that particular procedure code?
http://www.opendental.com/manual/reportdailyprocs.html
http://www.opendental.com/manual/reportdailyprocs.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com