SNOW_FILTER_JOURNAL_ENTRIES Function

This function is only supported when the Source Server is Service Now.

Parameters (String, String);

Returns: String;

This function takes the display value from a Service Now Journal List field and extracts all entries that relate to the journal entry type shown in the display values. It is intended to allow extraction of a subset of journal entries without the need to extract records individually from the sys_journal_field table.

The first parameter is the display value for a journal list field

The second parameter is the journal entry type that you wish to include

Example:

For an incident, the journal entry list field (dv_comments_and_work_notes)has a display value of:

2022-07-07 15:46:32 - System Administrator (Additional comments)
Customer Comment 3

2022-07-07 15:46:25 - System Administrator (Additional comments)
Customer Comment 2

2022-07-07 15:46:16 - System Administrator (Work notes)
Work Notes 2

2022-07-07 15:46:10 - System Administrator (Work notes)
Work Notes 1

2022-07-07 15:45:20 - System Administrator (Additional comments)
Customer comment 1

The Assignment Expression below is used to map the target string field:

SNOW_FILTER_JOURNAL_ENTRIES([dv_comments_and_work_notes],'Additional comments')

The output string will be the following, i.e it will include only the Additional comments and not the Work notes:

2022-07-07 15:46:32 - System Administrator (Additional comments)
Customer Comment 2

2022-07-07 15:46:25 - System Administrator (Additional comments)
Customer Comment 2

2022-07-07 15:45:20 - System Administrator (Additional comments)
Customer comment 1

Notes on Use:

If the first parameter is NULL, NULL will be returned

If the second parameter is NULL, NULL will be returned

If there are no journal entries (first parameter) of the type identified in the second parameter, NULL is returned.

Note that this function relies on the formatting of the journal entries having the following format:

<19 char timestamp> - <user name> (<type>)

<message>

If this format is not followed, no matches will be found.