Querying Records using REST API

Summary

Querying Records using REST API

Content

Hi All,

I am trying to retrieve active employees with Projected End Date less than sysdate using REST.

Getting below error URL request parameter q with value (assignments.AssignmentProjectedEndDate < '2019-05-15') and (assignments.AssignmentStatus = "ACTIVE") is not valid.

Do you have any idea to do this?

Thanks,

Parthiban

 

Version

19B

Code Snippet

https://[EndPoint]/hcmRestApi/resources/11.13.18.05/emps?q=(assignments.AssignmentProjectedEndDate < '2019-05-15') and (assignments.AssignmentStatus = "ACTIVE")