Custom Token in the alert composer
Summary:
I have created a custom alert composer in the name of Anniversary. Here I have pulled in the filter for the adjusted service date and have given the below parameters.
exists (SELECT * FROM PER_SENIORITY_DATES_F WHERE TO_CHAR(SENIORITY_DATE,'DDD')>TO_CHAR(SYSDATE+2,'DDD') and TO_CHAR(SENIORITY_DATE,'DDD')<= TO_CHAR(SYSDATE+3,'DDD') and SENIORITY_DATE_CODE = 'UL_ADJ_SERV_DT')
This date has to be pulled in the message template, request you to let me know what token is to be used.
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):