LE Activity Set Date Trigger

[NMeyer524]

Hoping someone will be able to assist.

We have an activity set called 'On Leave' with a date trigger. The date that triggers the activity set may change (leave start date). When the leave start date is updated by the user via an employee request, the On Leave activity set does not trigger based on the new date.

Is an activity set date trigger based solely on the date in that field when the lifecycle event case is created? ie, if that date is ever updated, the activity set won't trigger on the new date? If so, any ideas how we can make that happen?

[SwarnadeepNandy]

Hello @NMeyer524,

The activity set date trigger is based on the date in the field when the lifecycle event case is created. However, you can use a script to update the activity set date trigger when the leave start date is updated. Here is an example of how you can do that:

• Create a business rule on the HR Case table that runs on update and has a condition to check if the leave start date field has changed.
• In the script section of the business rule, use the GlideRecord API to query the Lifecycle Event Activity Set Trigger table (sn_hr_le_activity_set_trigger) and find the record that matches the current HR case and the activity set name ‘On Leave’.
• Update the date field of the activity set trigger record with the new leave start date value from the current HR case.
• Commit the changes to the database.

This way, you can ensure that the activity set date trigger is always in sync with the leave start date of the HR case.

Hope this helps.

Kind Regards,

Swarnadeep Nandy

[NMeyer524]

Thanks for the reply @SwarnadeepNandy . I do not see the Lifecycle Event Activity Set Trigger Table. I see the sn_hr_le_activity_set table and sn_hr_le_activity_set_context table. I am not sure which holds the actual record.