Alert to Notify the learners when Offering Activity has been updated
Summary:
Alert to Notify the learners when Offering Activity has been updated
Content (please ensure you mask any confidential information):
We are trying to build an alert to notify the employees when an activity of an offering which they are enrolled into has been updated.
Below filter is being used to restrict the data on the updated activity only but facing an error message while trying to Apply the filter as below:
The filter expression is invalid. The error message is: EXISTS (SELECT 'X' FROM WLF_LEARNING_ITEMS_F WHERE LEARNING_ITEM_TYPE = 'ORA_ACTIVITY' AND LEARNING_ITEM_NUMBER in ${activityNumber} AND TRUNC(LAST_UPDATED_DATE) = TRUNC(AlertFilterUtils.getSysdate()) AND TRUNC(AlertFilterUtils.getSysdate()) BETWEEN TRUNC(EFFECTIVE_START_DATE) AND TRUNC(EFFECTIVE_END_DATE) ). (HRC-1035496)