If Incident ticket has an attachment, make a field true.

prabhmeet · ‎01-26-2019

Hi,

I want that if incident has an attachment attached the field should show as true, otherwise false.

I am new to servicenow and not good at coding but I have written the following before business rule code on incident table.

Please also let me know Client Script is better or Business Rule.

Below mentioned code is not working. Can someone please help me with the mistake?

var rec = new GlideRecord('incident');
rec.addQuery('sys_id', current.incident_sys_id);
rec.query();
if(rec.next()){
if(rec.hasAttachments()){
rec.u_attachment= true;
}
}

Thanks

Ajaykumar1 · ‎01-26-2019

Hi ,

I tried the following code in a before insert, update BR in my dev instance, which is working fine,

(function executeRule(current, previous /*null when async*/) {

	if(current.hasAttachments()){		
	current.setValue("u_has_attachment","true");
					 gs.addInfoMessage("Attachment Present");
	}
	else if(!current.hasAttachments())
		{
	        current.setValue("u_has_attachment","false");
					 gs.addInfoMessage("Attachment Absent");
			
		}

Regards,
Ajay

View solution in original post

prabhmeet · ‎01-26-2019

it is a checkbox.

prabhmeet · ‎01-26-2019

Hi Ravi, any idea what the error is in the script?

Ravi T · ‎01-26-2019

var attachment = new GlideRecord('sys_attachment');
attachment.addQuery('table_name','incident');
attachment.addQuery('table_sys_id',current.sys_id);
attachment.query();
if (attachment.next()) {

current.u_attachment = true ;// Here you can return true
}

else {

current.u_attachment = false ;

}

prabhmeet · ‎01-26-2019

not working, I tried it.

Ravi T · ‎01-26-2019

write a client script onsubmit

var sys_id = gel('sys_uniqueValue').value;

var attachment = new GlideRecord('sys_attachment');

attachment.addQuery('table_name','incident');

attachment.addQuery('table_sys_id',sys_id);

attachment.query();

if (attachment.next()) {

g_form.setValue('u_attachment',true);

}

else{

g_form.setValue('u_attachment',false);

}