How to convert True/False value into Yes/No to display in the Notification

[Vamshi1]

We have workaround field (Column name : u_srt_workaround) with Type : True/False in the Incident form and the same i am using it in the Email template to display the value (${incident_alert.source_incident.u_srt_workaround}) for major incident module .But the requirement is like whenever "True" has been selected in the workaround it has to display the Value as "Yes" instead of True in the Notification. And if "False" is selected in the Notification it has to display value as "No" in the notification instead of false. Could you help me to achieve this.

[Allen Andreas · Accepted solution]

Hi,

Try changing your mail script to:

if (current.getTableName() == 'incident_alert_task') {
if (current.source_incident.u_workaround) {
template.print("Yes");
} else {
template.print("No");
 }
} else if (current.getTableName() != 'incident_alert_task' && current.u_workaround) {
template.print("Yes");
} else {
template.print("No");
 }
}

You can try that. The main point here is that you may not be using this on the incident table that can see the workaround field you have...so you need to establish where you are as far as what table this mail script is ran on and then use the appropriate dot-walking to get you there.

Please use the above as an example.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Vamshi1]

Hello Allen,

Could you please elaborate more on this.

[Nisar Khan1]

Create a mail script using below URL

https://instance name.service-now.com/sys_script_email_list.do?sysparm_userpref_module=a52de313ef0111002841f7f775c0fb67&sysparm_clear_stack=true

and call this mail script in the notification

${mail_script:name_of_mail_script}

[Vamshi1]

Hello Nisar,

Thanks for your information.

I have followed the above steps and created the email script in my personal instance with field name as u_workaround.But always it is printing 'No' value in the Notification for workaround = true records as well. Did I miss anything? Could you please guide me. 

[ajayr]

Hello,

Just remove the quotes from true it will work. 

if(current.u_workaround == true){

}

Reason: This is a boolean type of field and not a string

Thanks,

Ajay