Hi,
Having such of Dataverse table model:
EntityA--navigation property x -->EntityX--navigation property y-->EntityY with column 'address'
is it possible to query for EntityA but filter on address from EntityY.
I tried this way:
...&$filter=x\y\name eq 'some value'
or
...&$filter=contains(x\y\name, 'some value')
In both cases I get an error:
"error": {
"code": "0x80040216",
"message": "entityRelationshipRole for given navigation property not found"
}
....