How to filter field in loopback from the include model?

Question

I have this query:

UserModel.find({

    filter: {
        include: 
        [
            "communications",
             "roles"
        ],
        where : {
            "object_type" : 1
        }
    } 
}, function(data){
    $rootScope.users = data;
});

I want to get all the data from communications model filter by the field "object_type" but it doesn't work as I want.

My Communications model looks like this:

...
"properties": {
"object_type": {
  "type": "number"
},
"object_id": {
  "type": "number"
},
"communications_type_code": {
  "type": "number"
},
"address_type": {
  "type": "number"
},
"contact_value": {
  "type": "string"
},
"notes": {
  "type": "string"
},
....

A.Z. · Accepted Answer · 2017-05-05 14:40:12Z

1

To query related models you have to use relation scope. In your case that would be something like this:

UserModel.find({
    filter: {
        include: 
        [
            {
              "relation": "communications",
              "scope": { 
                "where": {"object_type": 1}
              }

            },
            "roles"
        ]
    } 
}, function(data){
    $rootScope.users = data;
});

Check the docs about "Querying related models"

answered May 5, 2017 at 14:40

A.Z.

1,6482 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andres Rodriguez · Accepted Answer · 2017-05-04 16:30:40Z

0

Oded, I believe you do not need the filter property in the search parameter. It should read like this:

UserModel.find({
    include: [ "communications", "roles" ],
    where : { "object_type" : 1 }
}, function(data){
    $rootScope.users = data;
});

Also make sure that the other entities that you add to include have a relationship to the queried model. Is it really UserModel or should it be CommunicationsModel?

answered May 4, 2017 at 16:30

Andres Rodriguez

1291 silver badge11 bronze badges

Collectives™ on Stack Overflow

How to filter field in loopback from the include model?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related