How to use Field Map Variable for iCalendar mapping

[Darren Lau]

On the Field Map (sys_impex_entry) table, how do you use the "Variable name" field with Type = var?  I'm building an Import Export Map for my icalendar email template.  I want to be able to map catalog variables from sc_req_item to display in the icalendar meeting invitation that gets sent out.  But I'm not seeing any sort of documentation or posts on how to make it work.

1.  Go to Import Export Map

2.  Open record where type is icalendar

3.  Under "Field Maps" tab of related links, click New

4.  In the Mapping Entry Wizard, choose Mapping to a variable name

How does this record work?  In the Variable name field i'm entering different options like current.variables.variable_name, variables.variable_name, and just plain variable_name.  But nothing is working.  Can someone explain to me how to use this correctly?

[Darren Lau]

I've opened up a case with HI on this and will report back what I find out.

[Darren Lau]

So my original intent was to map two date/time catalog variables from sc_req_item or sc_task to the start and end times of the icalendar notification.  HI has no documentation on how to use the Variable Name field on the Field Map (sys_impex_entry) table and cannot tell me what it is for.  So i'll be forced to create some custom date/time fields on sc_req_item or sc_task and just use the database field mapping instead.

[hongsok]

Hi Darren,

Are you able to make to work by create custom field on the sc_req_item table?

If so could you please share?

Regards,

Hong

[Darren Lau]

Hi Hong,

ServiceNow was never able to tell me how to use the variable feature so that I could map directly to a catalog variable.  So instead I had to create two date/time fields on the sc_task table.  I would populate these fields with values that were gathered from the catalog item variables that the end user inputted. I really didn't want to add more custom fields to the sc_task table that were not going to be used very often but that was my only choice.