issue on querying data for hasMany through relation about loopback-connector-mysql HOT 3 CLOSED

it works well on loopback-connector-mysql version: 1.7.0

from loopback-connector-mysql.

I've a similar problem;

var filter = {
  where: { userId: userId},
  include: {
    relation: 'challenger',
    scope: {
      include: {
        relation: 'leagues',
        scope: {
          where: { id: 1 }
        }
      }
    }
  }
};

results in

sql: 'SELECT `id`, `name` FROM `League` WHERE `id` IN (3,4,5,6) ORDER BY `id`'

In my case the WHERE id=1 part is missing. I think this is because it has been overridden by the WHERE id IN part which is required for the include relation.

from loopback-connector-mysql.

@TonyLuo If the problem is "scope filter" is applied on throughModel not relatedModel, I believe it's fixed in loopbackio/loopback-datasource-juggler#1153, the fix is on 3.x version but hasn't beed backported to 2.x(under discussion)

If that is not the case, can you fork https://github.com/strongloop/loopback-sandbox and replace with your use case? Thanks. I will try to reproduce it.

from loopback-connector-mysql.