How to nested include through models relationships LOOPBACK?

Question

Lets continue with the Patient - Physician analogy from the Loopback Docs. Let's make the assumption that Physician model looks like this:

{
   "id": "4654654654654654654",
   "name": "John Doe"
}

and Patient model looks basiclally the same (only id and name) and two models are connected with HasManyThrough relationship with through model called Appointment as in the docs. https://loopback.io/doc/en/lb2/HasManyThrough-relations.html

My question is, when you GET to /api/physicians url how can you query the response so it includes the appointment date as well as patient for every physician?

Wanted output:

{
  "id": "4654654654654654654",
  "name": "John Doe",
  "patients": [
     { "id": "1321232313", "name": "First Patient", "appointment_date": 1995-12-17T03:24:00 },
     { "id": "1321232313", "name": "Second Patient", "appointment_date": 1995-12-17T03:24:00 }
  ]
}

Field "appointment_date" is the date from the appointment through model and patient names are obtained through nested including of same model.

Any thoughts?

Possible duplicate of Return join table attributes in incluce with loopback — Ivan Schwarz
It is similar question indeed, but the point of my question is how you can get the list of all Physicians, and within every Physician obj the list of all Patients with respective appointment dates. The question you mentioned is about getting all data about one instance of Physician querying with the psysician id. — Jakša Mališić

IftekharDani IftekharDani · Accepted Answer · 2018-01-24T05:53:21

Use Nested Include Just check link Its help.

Please check this Code :

    physicians.find(
{
  include: {
  "relation": "Appointment",
  "scope": {
    "fields": ["id", "patientId", "AppointmentDate", "physiciansId"], /*need to include both Person and PersonID fields for this to work*/
    "include": {
      "relation": "patient",
      "scope": {
        "fields": {"id": true, "patienName": true},
         where: {id: patientId},
      }
    }
  }
}
}

How to nested include through models relationships LOOPBACK?

1 Answers