Get [code] and [/code] fixed in email scripts

[lakshmi75]

Hello ,

Im getting [code] and [/code] while fetching latest worknotes alone through email scripts.

(function runMailScript(current, template, email, email_action, event) {

    var fieldName = 'work_notes';

    var rec = new GlideRecord('sys_journal_field');
    rec.orderByDesc('sys_created_on');
    rec.addQuery('name', current.getTableName());
    rec.addQuery('element', fieldName);
    rec.addQuery('element_id', current.sys_id);
    rec.setLimit(1);
    rec.query();
    if (rec.next()) {
        template.print("Below Worknotes have been added to the Case" + rec.value);
    }
    while (rec.next()) {
        parsedEntry = (rec.getElement("value")
                .getHTMLValue())
           // .replace(/\[\s*(\/|)\s*code\s*]/gi, '');
		.replace(/\[code\]|\[\/code\]/gi, "");
    }

})(current, template, email, email_action, event); //

I have tried all the ideas posted in community but still didnt get it fixed.

Please suggest me if there is any solution

[palanikumar · Accepted solution]

Hi,,

Change the script as below

(function runMailScript(current, template, email, email_action, event) {

    var fieldName = 'work_notes';

    var rec = new GlideRecord('sys_journal_field');
    rec.orderByDesc('sys_created_on');
    rec.addQuery('name', current.getTableName());
    rec.addQuery('element', fieldName);
    rec.addQuery('element_id', current.sys_id);
    rec.setLimit(1);
    rec.query();
    if (rec.next()) {
        var parsedEntry = (rec.getElement("value").getHTMLValue()).replace(/\[code\]|\[\/code\]/gi, "");
        template.print("Below Worknotes have been added to the Case" + parsedEntry;
    }

})(current, template, email, email_action, event); //

[lakshmi75]

Thanks Palanikumar! It worked  and issue got fixed

[palanikumar]

Hi,

Mark my response as correct answer if it fixed your issue. You can't mark two response as correct answer

Thank you,

Palani

[Ankur Bawiskar]

Hi,

seems your value of worknotes had HTML code inside it and hence it's giving that

try this

(function runMailScript(current, template, email, email_action, event) {

	var fieldName = 'work_notes';

	var rec = new GlideRecord('sys_journal_field');
	rec.orderByDesc('sys_created_on');
	rec.addQuery('name', current.getTableName());
	rec.addQuery('element', fieldName);
	rec.addQuery('element_id', current.sys_id);
	rec.setLimit(1);
	rec.query();
	if (rec.hasNext()) {
		template.print("Below Worknotes have been added to the Case" + rec.value);
	}
	while (rec.next()) {
		var strWorkNotes = rec.value;
		var r = new RegExp('\\[\/code\\]', 'g');  
		strWorkNotes = strWorkNotes.replace(r, '');  
		var r1 = new RegExp('\\[code\\]', 'g');  
		strWorkNotes = strWorkNotes.replace(r1, '');  

		template.print(strWorkNotes);
	}

})(current, template, email, email_action, event); //

Regards
Ankur