Some Data We Can Not Found in Query #43132

[beacondental]

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

[SLeon]

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

[beacondental]

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?

[SLeon]

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

[beacondental]

Yes, please add it to SheetFields GET

[SLeon]

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