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

Question

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.

not supported it seems, see http://stackoverflow.com/questions/25903985/how-to-include-related-entities-in-rest-with-loopback-io — superkhau, Nov 20 '14 at 01:10

score 7 · Accepted Answer · answered Aug 21 '15 at 08:39

7

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

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

answered Aug 21 '15 at 08:39

Hidde Stokvis

Is this part of the model? – Bill Nov 17 '16 at 18:37
@Bill Look at [include filter docs](http://loopback.io/doc/en/lb2/Include-filter.html) – ANTARA Feb 22 '17 at 12:40

Alex V · Answer 2 · 2014-11-19T22:46:51.730

2

As far as I understood this question is about adding a nested filter on an include level, which seems to be not yet supported: https://groups.google.com/forum/#!msg/loopbackjs/T6onsYMJFOI/V4ILc3Obf3MJ

May be it's not the best way to approach this problem, but what you can do is a manual response transformation in .afterRemote('find', ...) hook.

edited Nov 19 '14 at 22:46

answered Nov 19 '14 at 22:36

Alex V

score 0 · Answer 3 · edited Jul 28 '15 at 13:12

0

/users?filter[fields][0]=name

edited Jul 28 '15 at 13:12

ndsmyter

answered Nov 18 '14 at 18:20

superkhau

This doesn't work for included objects. And I need only "name" for **related** (or embedded) user objects! – IvanZh Nov 19 '14 at 07:32
do any of use cases in the example repo meet your use case? maybe this one /api/customers?filter[include][reviews]=author&filter[where][age]=21 – superkhau Nov 19 '14 at 18:36
I saw the use cases, but they don't limit fields returned from relation. As Alex Voitau said, this isn't supported yet. Nevertheless thanks for response! – IvanZh Nov 20 '14 at 06:57

3 Answers3