filter with related model's properties

[FelipeAguayo]

I have the following situation:

Model:

{
  "name":"Model",
  "plural":"Models",
  "idInjection":true,
  "properties":{
     "name":"string"
  },
  "relations":{
    "relOtherModel":{
      "type": "belongsTo",
      "model": "OtherModel",
      "foreignKey": "idOtherModel"
    }
  }
}

values Model:

[ {id:1, idOtherModel:1, name:'one'}
, {id:2, idOtherModel:1, name:'two'}
, {id:3, idOtherModel:2, name:'three'}
, {id:4, idOtherModel:3, name:'four'}]

OtherModel:

{
  "name":"OtherModel",
  "plural":"OtherModels",
  "idInjection":true,
  "properties":{
     "name":"string",
     "state":"string"
  }
}

values OtherModel:

[ {id:1, name:'otherOne', state: 'created'}
, {id:2, name:'otherTwo', state: 'deleted'}
, {id:3, name:'otherThree', state: 'created'}]

I want to get the values of "Model 1" that belong to "OtherModel" with state "created".

Example:

• [ GET ] http://localhost:3000/api/Models?filter={"where":{"relOtherModel.state":"created"}}
• Model.find({where:{"relOtherModel.state":"created"}}, function(err, models){});
• Other Solution.

Result values:

[ {id:1, idOtherModel:1, name:'one'}
, {id:2, idOtherModel:1, name:'two'}
, {id:4, idOtherModel:3, name:'four'}]

Any solution? :(

PD: the query must be from Model.

[jlvdh]

Seems related to: strongloop/loopback#517

[superkhau]

@FelipeAguayo Can you verify if your issue is related to strongloop/loopback#517?

[FelipeAguayo]

yes, but i'm working with the mysql connector.

[superkhau]

Thanks. I will mark this issue as a duplicate.

[bajtos]

I think this is not exactly a duplicate of strongloop/loopback#517, let's keep it open.

[bajtos]

Actually let's use strongloop/loopback#683 to keep track of this feature request.

[pookdeveloper]

This is not resolved yet ? Thanks

[bajtos]

This is not resolved yet ?

No, see strongloop/loopback#683