Learning Assignments Due Soon (30 Days)-does not work

Summary:

Alert Runs Empty Despite Filters Targeting unfinished Required Assignments.

Content (please ensure you mask any confidential information):

We are encountering an issue where the alert runs empty despite the applied filters. The alert is configured to run daily and targets all required assignments (excluding voluntary assignments) with due dates within the next 30 days.

The filters applied are as follows:

• Status: ${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'
• Type: ${learningItemType} = 'ORA_COURSE' OR ${learningItemType} = 'ORA_SPECIALIZATION'
• Assignment Type: ${assignmentType} = 'ORA_REQUIRED_ASSIGNMENT'
• Due Date: TRUNC(${assignmentDueDate})= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(),+30)}

Despite these configurations, the alert does not return any results in the output.