Open Dental Forum

Hello Team,

We are trying to fetch data from commlogs, whether the an email is sent or not to patient.
And we found that we are able to see the list in the patient-->account section, but the same logs are not visible if we try to fetch using user query or using GET-API ("/commlogs?PatNum="). In fact, the results are just showing text and not email.

I am attaching the screenshots of records for reference. The patient no is 30432.

This might help you, It's my assumption that, we are not getting data if the 'Type' field is empty in commlogs.

Please guide us on how to get all the data and not just the data where commType is not empty.


Thank you.

Good morning,

The "Communications Log" grid in your second screenshot contains more than items in the commlog table. It also contains information for that patient from the emailmessage, formpat, and sheet tables. To get emails for a patient, you can use a query to select rows from that table using their PatNum.

Good morning,

Following your suggestions, I get the required data in 'emailmessage' table.

Thank you,