Apply a where filter to the related model

[anibalaguirreconsultora]

Hello

I am doing some test queries using your plugin over a loopback application.

I want to apply a where filter to the related model .

Does the "where" parameter of type JSON works with related model properties ?

In the below example: the second "where" filter (where: {name: "SMH"} ) on the related model is not working ..

query ListEntities($where: JSON!) {
allEntityRoles(where: $where, first: 10) {
totalCount
EntityRoles {
id
entity(where: {name: "SMH"}) {
edges {
node {
id
entCode
name
}
}
}

}

}
}

variable:
{
"where": {
"CompanyId": "aa5d2125-bcfc-4808-ae55-5aec699f3509",
"EntityRoleTypeId": "f3e03826-28cb-4d72-ad71-7b5e174dbfb9"

}
}

[Tallyb]

check out this test

loopback-graphql/__test__/query.spec.ts

Line 37 in 3401c75

describe('Multiple entities', () => {

It should work.

[anibalaguirreconsultora]

it works only for the parent model, not by the nested/related models properties

might be related to this loopback open issue?
strongloop/loopback#517

i installed postgraphql wich talks to postgres db directly not through the loopback models and i was able to run a query filtering by properties on the related/nested models.