GENERATE_JSM_NOTES_ARRAY Function

This function is only supported for ServiceNow -> Jira, BMC Remedy -> Jira and Cherwell -> Jira migrations.

Parameters (String, String, Boolean);

Returns: String;

Its intended use is to construct an array of comments or work logs together with their original author, create date and whether it is public (customer visible) or not.

The first parameter is the name of the source form to read the comments/work logs from.

The second parameter is the name of the field on that form that stores the entry id (for example sys_id, rec_id) of the ticket that you are migrating (for example, Incident, Problem, Change Request).

The third parameter is a Boolean flag to indicate if the comment or work note is public or not. Set this to TRUE for public or FALSE otherwise.

Example:

GENERATE_JSM_NOTES_ARRAY('sys_journal_field','element_id',TRUE)