Search code examples
loopbackjsstrongloopjugglingdb

Loopback 2.4: how to query certain fields of related model via REST API

I have User model over relational DB.

Each User can hasMany "users" where "chiefId" is FK.

"relations": {
    "users": {
      "type": "hasMany",
      "model": "User",
      "foreignKey": "chiefId"
    },
}

I can query related users for each chief-user like this:

GET /users?filter={"include":"users"}

But it returns full user objects.

  • How should I query only "name" properties of related users?
  • Also is it possible to count related instances in one request to server?
Solution

  • A late reply but I just ran into this question now. It is possible:

    filter: {
 include:{
  relation: "users",
  scope: {
   fields:["name"]
  }
 }
}