Hi Alex. You can't use a Compare condition directly on a referenced object field (x.y). You have to use a Compare _condition with the _In operator to achieve that. Here's a sample provided by my colleague which does something similar:
{
"Fields": "ActualEffort,ExpectedROI,Score,Title,Work",
"Orders": [
{
"FieldName": "Title",
"Order": "Ascending"
}
],
"TypeName": "Issue",
"Where": {
"LeftExpression": {
"FieldName": "CreatedBy"
},
"Operator": "In",
"RightExpression": {
"Query": {
"TypeName": "User",
"Where": {
"LeftExpression": {
"FieldName": "ExternalId"
},
"Operator": "Equal",
"RightExpression": {
"Value": "243edda2-622c-4f8a-a9e6-d677a1976607"
}
},
"_type": "EntityQuery"
},
"_type": "QueryExpression"
}
},
"Paging": {}
}
Hope this helps,
Ophir