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

Ravi T · ‎01-26-2019

then remove the alerts

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()) {

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

else {

current.u_attachment = false ;

}

prabhmeet · ‎01-26-2019

Hi Ravi, Still it is not working.

Ravi T · ‎01-26-2019

which business rule you used?

prabhmeet · ‎01-26-2019

I used before insert, update BR. I read that gel function is mostly used in client scripts. Can we use it in a BR?

Ravi T · ‎01-26-2019

what type of field is u_attachment?