How to do where condition on include relation in Loopback

Question

I want to get the result with include relation with where condition on include model.

return this.htcApi.find({
  include: [
    {
      relation: 'nmos',
      scope: {
        include: 'countries',
      },
    },
  ],
  where: { name:'Welcome', "nmos.name":'agile'}
});

This where is condition work for name of htc model not for noms module.

I want query like

Select htc.*, nmos.* FROM htc LEFT JOIN nmos ON nmos.id = htc.n_id where htc.name = 'abc' and nmos.name = 'abc';

How can add where condition on the "relation" table?

Shubham · Accepted Answer · 2020-07-17 11:57:05Z

1

Simply you need to add where clause in 'scope' object which lies inside the 'include' object. So the code would be like :

    return this.htcApi.find({
    include: [
      {
        relation: 'nmos',
        scope: {
          include: 'countries',
          where:{name:'agile'}
        },
      },
    ],
    where: { name:'Welcome'}
  });

answered Jul 17, 2020 at 11:57

Shubham

1701 silver badge7 bronze badges

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

Comments

Orlyyn · Accepted Answer · 2020-07-16 13:41:58Z

0

In your query, you just need to add the property where within the scope property, like this:

return this.htcApi.find({
  include: [
    {
      relation: 'nmos',
      scope: {
        include: 'countries',
        where: {
          and [
            { id: htc.n_id },
            { name: 'abc' },
          ],
        },
      },
    },
  ],
  where: { name: 'abc' }
});

This should return the htcApi objects named 'abc' with the related nmos objects that have the name 'abc' and the id 'n_id'.

answered Jul 16, 2020 at 13:41

Orlyyn

2,6222 gold badges25 silver badges40 bronze badges

1 Comment

Orlyyn Over a year ago

I assumed you already had it before making the request! Indeed it's not defined in the code provided

Collectives™ on Stack Overflow

How to do where condition on include relation in Loopback

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related