Query filter not work with include

[frbuceta]

Steps to reproduce

When sending a request to a GET method with a query object like this:

{
  "limit": 1,
  "include": [
    {
      "relation": "user"
    }
  ]
}

this does not work.
Inside the controller you only receive: { limit: '1' }

@raymondfeng @bajtos

[frbuceta]

Extending the previous comment

I send through the explorer of

{
  "where": {},
  "fields": {
    "id": true,
    "userId": true,
    "type": true,
    "key": true,
    "value": true
  },
  "offset": 0,
  "limit": 1,
  "skip": 0,
  "order": [
    "string"
  ],
  "include": [
    {
      "relation": "user",
      "scope": {
        "where": {},
        "fields": {},
        "offset": 0,
        "limit": 1,
        "skip": 0,
        "order": [
          "string"
        ]
      }
    }
  ]
}

Loopback receipt: { offset: '0', limit: '1', skip: '0' }

[frbuceta]

The problem is in the explorer. Since Postman works!

[irineul]

hi, @frbuceta could you send your controller method?

[frbuceta]

It is a controller generated by default with the CLI

  @get('/vehicles', {
    responses: {
      '200': {
        description: 'Array of Vehicle model instances',
        content: {
          'application/json': {
            schema: {type: 'array', items: getModelSchemaRef(Vehicle)},
          },
        },
      },
    },
  })
  async find(
    @param.query.object('filter', getFilterSchemaFor(Vehicle)) filter?: Filter<VehicleWithRelations>,
  ): Promise<Vehicle[]> {
    return this.vehicleRepository.find(filter);
  }

[irineul]

Ok, and now please send me your Vehicle Model and User Model.

[agnes512]

@frbuceta I quickly tried your query with our todo-list example with query

{
 "limit": 1,
 "include": [
   {
     "relation": "todoList"
   }
 ]
}

I got

[
 {
   "id": 1,
   "title": "Take over the galaxy",
   "desc": "MWAHAHAHAHAHAHAHAHAHAHAHAHAMWAHAHAHAHAHAHAHAHAHAHAHAHA",
   "todoListId": 1 // this is wrong
 }
]

But when I tried it with url:

http://127.0.0.1:3000/todos/?filter[limit]=1&filter[include][][relation]=todoList

, I got the correct result:

{ "id":1,
  "title":"Take over the galaxy",

 "desc":"MWAHAHAHAHAHAHAHAHAHAHAHAHAMWAHAHAHAHAHAHAHAHAHAHAHAHA",
 "todoListId":1,
 "todoList":{
    "id":1,
    "title":"Sith lord's check list"
  }
}

( I am using this example)

I think that's a bug in our API Explorer when it filters limit and include..

Could you try the url and see if it returns the expected result? Thanks.

[bajtos]

It's a known bug of our API Explorer that filter fields like include are not supported - see #2208.

[dhmlau]

Closing as duplicate of #2208. Please continue the discussion over #2208. Thanks!