2 followers Follow

CZQL by RegularResourceLink fields

Hi Guys,

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.

Query :
select ReportedBy, WorkItem, BillingRate, HumanResource.C_BillingRate
from Timesheet
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 ? 


Mustafa Kipergil Answered

Official comment


Hello Mustafa,

Currently we only support conditions with static values (for example:"ReportedBy = '/User/7dffc44f2fde49018db62e8a571a78c2'").

To accomplish your query you will need to do the filtering on your application side.


I hope this helps,


Elad Franklin
Comment actions Permalink

Please sign in to leave a comment.



Hi again,

What do you mean by saying the application side? 

Since the application is not allowing me to make such a comparison, 
I am trying to filter our dataset via API.

And are you saying that CZQL and UI are not supporting to compare 2 fields, is that right? 

Please check this post.


Mustafa Kipergil 0 votes
Comment actions Permalink

Hi Mustafa,

The API does not support comparing two fields. By "application side" I mean that you should retrieve all the needed data and then filter it in your code. So you should retrieve both C_BillingRate and BillingRate and in your application do the comparison.


I hope this helps,


Elad Franklin 0 votes
Comment actions Permalink