Can you query multiple attributes on a child object?
Summary:
I'm trying to get everyone in a department (workRelationships.assignments.DepartmentId) not everyone who was EVER in the department, combining (workRelationships.assignments.DepartmentId = 1 AND workRelationships.assignments.PrimaryFlag = true) seems to apply them independently to the array, so anyone with any assignment with a departmentid = 1 and any assignment that has a primaryflag= true even if it's not the same assignment.
Content (required):
Version (include the version you are using, if applicable):
REST-Framework-Version:8
Code Snippet (add any code snippets that support your topic, if applicable):
/hcmRestApi/resources/latest/workers?q=workRelationships.PrimaryFlag = true AND workRelationships.assignments.PrimaryFlag = true AND workRelationships.assignments.DepartmentId = 1 &effectiveDate=2022-08-04