Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
For more information, please refer to this announcement explaining best practices for getting answers to questions.
how to add no of days in Alert Composer Message Body
Summary:
Build Custom Resource Alert
Resource Type: Emps
In the Template Body/Message body we need to print below details.
Content (required):
Message Body
********************************************************************************
The below colleagues Visa is due to expire:
Colleagues Name Visa Expiry Date
${AlertUtils.loop('emps','<br>${emps.DisplayName}<br>')} ${AlertUtils.getSysdate()+30}
********************************************************************************
Expected outcome:
In Visa Expiry Date it should print SYSDATE+30 value. for instance, today is 31st May 2023 so, in the output it should print 30th June 2023
Version (include the version you are using, if applicable):
Not Applicable
Code Snippet (add any code snippets that support your topic, if applicable):
SQL used to fetch Employee Records.