Filter in resource alert for overdue learning

Summary:

Hi Team. I've created a resource alert for unfinished overdue courses but it keeps being sent to learners with completed  as well as exempted assignments.

Content (please ensure you mask any confidential information):

I based my alert on the following filters:

• ${learningItemNumber} = ANY (****)   to identify the courses
• TRUNC(${assignmentDueDate}) < ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(),0)}    for overdue assignments
• ${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'    for unfinished assignments

What am I missing? Could you help with defining the filters that will send the alert to ONLY active assignments (i.e. "not started", "in progress" or "no active offering")
also tested adding the following filters, but it made no difference: