filter workers by the current assignment status

Summary:

My aim is to filter workers by the status of their current assignment.

Content (please ensure you mask any confidential information):

hi ,

my filter is like this-

 {

          "op": "$eq",

          "attribute": "workRelationships.assignments.AssignmentStatusType",

          "value": "{{$page.variables.assignmentStatus}}"

        },

but what happened is that the filter check if there is one of the assignments that has that status,

what i want to have on the attribute-

workRelationships.items[ $functions.maxRelation( workRelationships.items) ].assignments.items[0].AssignmentStatusType;

(maxRelation finds to m the current relationship)

but it dosnt work.

how can i filter by a spcific item of the workrelationship?

thank you very much!!