Open Dental Forum

Hi, Based on claims closed in a week, I'm looking to find patients with balance. I'm able to achieve half of my goal using query#246 but here are 2 issues I'm facing - and looking for help to resolve it. 1. Patients who have outstanding claims or claims that haven't been sent yet get included. 2. Pa...

Thanks, Alex. The next issue I'm facing is that when I run this query through the command line then I'm getting the error below ERROR 1270 (HY000) at line 12: Illegal mix of collations (latin1_swedish_ci,NUMERIC), (cp850_general_ci,IMPLICIT), (lati n1_swedish_ci,IMPLICIT) for operation 'between' Thi...

Can you also PM me the complete query that you used?

Actually, I need the line below because patients having this commType need to be excluded.

We wanted to track patients who are leaving without an appointment but not include those who have said they don't want to schedule a follow up/re-care appointment. I added a commlog type (439) for my staff to use so that the query can discard those patients. I've taken open dental example query 1265...