iCalendar Invites from Change Tasks

geeerard
Giga Guru

We have iCalendar invites working in our environment, which will send an Outlook Calendar invite to our Change Managers and Implementers assigned to each Change Request. For larger changes, I am attempting to put the same iCalendar invite on implementation Change Tasks. Almost everything is working correctly for the Change Task iCalendar invite, with the exception of the start and end date for the actual Outlook calendar. For this, I'm attempting to pull the Planned Start and End date/time from the Change Request to use for the Change Task calendar invite. Does anyone happen to know if this is possible?

For example:

The Change Request
Planned Start Date: 9:00 pm, March 16, 2018
Planned End Date: 9:00 pm, March 18, 2018

I open an implementation Change Task and want to have the iCalendar notification to go to the implementer to have a placeholder in their calendar for 3/16/18 9:00 pm to 3/18/18 9:00 pm

I'm posting the notification/template as well as the Import Export Map that I'm using; thanks in advance for any suggestions/help! (on a side note, we're on Jakarta - Patch 6)

Notification:
find_real_file.png

find_real_file.png

 

Template:
find_real_file.png

Import Export Map
find_real_file.png

1 REPLY 1

geeerard
Giga Guru

In case anyone has this issue in the future, I wanted to let you know we solved it with a Business Rule to populate the "Expected Start" and "Due Date" fields on the Change Task itself. (populated from the Parent Change Request)

For whatever reason, using the sys_impex_map table could not successfully grab the required date/time from the Parent Change Request...however, using the two fields on the Change Task works correctly.

Updated Field Maps for the icalendar.change_task Import Export Map (sys_impex_map table)

find_real_file.png

Business Rule

find_real_file.png

find_real_file.png