Can you guide me about the query below ?
What I want to list all timesheet entries, where the timesheets BillingRate field is different than its HumanResource.C_BillingRate value.
( this is a customer field on the regularresourcelink entity)
When I run it without the condition, it is bringing the values correctly, but when I use HumanResource.C_BillingRate in the condition, then it is giving me an error.
select ReportedBy, WorkItem, BillingRate, HumanResource.C_BillingRate
ReportedBy = '/User/7dffc44f2fde49018db62e8a571a78c2'
and HumanResource.C_BillingRate.value <> BillingRate.value
I also tried as :
and HumanResource.C_BillingRate <> BillingRate
and HumanResource.C_BillingRate != BillingRate
Do you know what is the correct way of using related entity fields in the condition clause ?