I am adding a filter criteria in Data group but the records are not getting filtered

Summary:

I am adding a filter criteria in a user entity PAY_ASSIGNED_F_RANGE_UE but the records are not getting filtered. all the records are showing up.

Content (please ensure you mask any confidential information):

I have added the filter criteria as ASSIGNF.primary_flag = 'Y', but still the records having ASSIGNF.primary_flag = 'N' are also showing up in the output

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

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