AS: Custom criteria not working for Workers with multiple Assignments

Summary:

Custom criteria is not working when we have an worker with multiple assignment and we have a restriction , it should not fetch specific department(s).

Content:

AND DEPT.NAME NOT IN ('Dept1','Dept2')

The custom criteria would work with single assignment but when the worker has multiple assignment, active and inactive records and we have records with the Department , it should not fetch record, still the criteria would fetch all assignment for the person including the departments with the above condition.

Version (include the version you are using, if applicable):

23C

Code Snippet (add any code snippets that support your topic, if applicable):