mysql filter where on relation

[dahuahe]

In model A

{ "name": "A",
  "base": "PersistedModel",
  "idInjection": true,
  "options": {
    "validateUpsert": true
  },
  "properties": {
    "AreaCode": {
      "type": "string",
      "default": ""
  }
  },
  "relations": {
    "B": {
      "type": "hasOne",
      "model": "B",
      "foreignKey": ""
    }
  }
}

In model B

{
  "name": "B",
  "base": "PersistedModel",
  "idInjection": true,
  "options": {
    "validateUpsert": true
  },
  "properties": {
    "Name": {
      "type": "string",
      "default": ""
    }
  },
  "relations": {
    "A": {
      "type": "belongsTo",
      "model": "A",
      "foreignKey": ""
    }
  }
}

if I find A with B like this /api/A {filter:{include:"B"}}} I will get this data

[{
id:1
AreaCode:"test1",
B:{Name:"xxxxx"}             // (if A id 1 hasOne B)
}.{
id:2
AreaCode:"test2",         //   (A id 2 don't haveOne B)
}......]

But I want to get this data

[{
id:1
AreaCode:"test1",
B:{Name:"xxxxx"}             // (if A id 1 hasOne B) only get data A has B  
},{                                         
id:3
AreaCode:"test1",
B:{Name:"XXXX"}
}......(A hasOne B's data)]

so I try find A with B like this /api/A
{filter:{include:"B",where:{B:{neq:''}}}}}} or
{filter:{include:"B",where:{neq:{B:''}}}}}}
it's doesn't work!!
How i to write filter ??or to do??

[0candy]

@dahuahe When you apply filters to related models, the query returns results from the first model plus any results from related models with the filter query, similar to a "left join" in SQL.
See https://docs.strongloop.com/display/APIC/Include+filter#Includefilter-Includewithfilters

[0candy]

See feature request #683.
Closing this issue as a dup.