Open Dental Forum

Hi, I run a customized query in mySQL workbench to get all appointment for certain day, however I can NOT get all appointments. If I run the same query inside Opendental Custom query, I can get all appointments. I list my query below. Another question, if I run this query in mySQL workbench, appointment.Confirmed and appointment.AptStatus are integers. How do I map them to text so that it make sense, e.g. it should say confirmed, scheduled as if I run insider Opendental Custom query. Any help is appreciated.

____________________________________________________________________________
use opendental;

SET @AptDateTime = '2018-11-15';

SELECT patient.LName,patient.FName, patient.HmPhone, patient.WkPhone, patient.WirelessPhone,
appointment.AptDateTime,appointment.IsHygiene,appointment.IsNewPatient, appointment.Confirmed, appointment.AptStatus,appointment.UnschedStatus
FROM appointment
LEFT JOIN patient ON appointment.PatNum=patient.PatNum
WHERE appointment.AptDateTime LIKE CONCAT(@AptDateTime,'%')
AND AptStatus != 6 /*Planned*/
AND AptStatus != 3 /*UnschedList*/

I run a customized query in mySQL workbench to get all appointment for certain day, however I can NOT get all appointments.

Most likely MySQL Workbench has some kind of row limit on its return set.
https://blog.sqlauthority.com/2014/01/1 ... rkbench-2/

How do I map them to text so that it make sense, e.g. it should say confirmed, scheduled as if I run insider Opendental Custom query. Any help is appreciated.

Mapping them to text outside of OpenDental is mostly a manual process. Looking through our database schema documentation will help you know how to get the correct text. Definitions can be linked to the correct Definition in the Definition table and then the ItemName can be queried. For enumerations you will just need to substitute the text for the values that you receive back (Example: If AptStatus=1, then the text would be "Scheduled")
https://www.opendental.com/OpenDentalDo ... ppointment

Thanks a lot for your reply. It turns out that I point to the wrong database. I am all set.