Hi 
Similar questions are raised in many threats but the solutions proposed do not fit my case. I have got a simple SOQL: 

Select WorkOrder.Id from TimeSheetEntry where WorkOrder.Id in (Select Id from WorkOrder Where...)

The error is The left operand 'WorkOrder.Id' cannot have more than one level of relationships. 

If I provide hardcoded Orders it works, so the relationship exists and is referred to properly as I understand. How to use the subquery?

Hi 
Similar questions are raised in many threats but the solutions proposed do not fit my case. I have got a simple SOQL: 

Select WorkOrder.Id from TimeSheetEntry where WorkOrder.Id in (Select Id from WorkOrder Where...)

The error is The left operand 'WorkOrder.Id' cannot have more than one level of relationships. 

If I provide hardcoded Orders it works, so the relationship exists and is referred to properly as I understand. How to use the subquery?

Hi 
Similar questions are raised in many threats but the solutions proposed do not fit my case. I have got a simple SOQL: 

Select WorkOrder.Id from TimeSheetEntry where WorkOrder.Id in (Select Id from WorkOrder Where...)

The error is The left operand 'WorkOrder.Id' cannot have more than one level of relationships. 

If I provide hardcoded Orders it works, so the relationship exists and is referred to properly as I understand. How to use the subquery?