To trigger Alert notification to community members for Community

Summary:

We want to trigger alert notification to community members for community for the below scenarios,

1. Notification to learner when Learner Added to community
2. Notification to Community Members on adding new Learning Items to catalog inside Community
3. Notification to Community Members while adding or replying to comments inside learning community

Content (please ensure you mask any confidential information):

1. Trigger Notification when Learner Added to community

Expressions used,

Resource - learnerLearningCatalogItems

Expression - ${learningItemType} = 'ORA_COMMUNITY'

AND

Resource - learnerLearningCatalogItems/userAccess

Expression - ${userAccessStatus} = 'ORC_ASSN_REC_ACTIVE'

Expression - TRUNC(${userAccessAddedOnDate}) <= ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(), -1)}

----Not working

Expectation is to trigger the alert hourly once to learners when learner added to a community