Open Dental Forum

Hello Sir/Ma'am,


I am working on an email service of 'Summary of records release by clinic' and use Query #43132, in that I need to find the reason why the patient is changing or moving to some other clinic

e.g: 21711-Richard F. (Choosing another doctor)

here the reason is choosing another doc.

This records will contain the list of patients having miscellaneous type of sheet field, I tried finding this reason in various tables like Sheet, SheetFields, Patient, Clinic but could not find it.

As I am not aware about the whole database structure, could you please shed some light on related table to 'Sheet' so that I can modify the query accordingly and fetch required data



Thanks and regards,
Raj Joshi
GlobalVox

Here is a link to our entire database schema that you can use to learn more about Sheets, etc.

For the MISC, I did find it in the database schema and it's under Reportable Name. But, how would I get this in the API Sheets? I do not see the reportable name in the API sheets. Or would it be in another API table?

"ReportableName" is a field in the Sheetfield table. We can add it to SheetFields GET, if you like.

Yes, please add it to SheetFields GET

I have added this to our development list. We will update this thread once it is completed.