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

Service_RNow · ‎01-26-2019

HI,

Please follow this link it's helpful you

https://community.servicenow.com/community?id=community_question&sys_id=6a5607e1db1cdbc01dcaf3231f96...

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

Ravi T · ‎01-26-2019

Hi Prabhmeet,

use the below code

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

alert ('There is an attachment.');// Here you can return true

}

else {

alert ('There is no attachment.');// Here you can return false

}

Mark it correct/helpful if it helps you

Regards

Ravindra

Ajaykumar1 · ‎01-26-2019

Hi Prabhmeet,

I think the script provided by Ravi will work.

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

> If you can achieve something by using a server side(in this case: Business rule) script than go with it, instead of using a client-side script.

Client-side programming is often preferred by users, due to the immediate interactivity of the scripts. Server-side programming is often preferred by developers due to eased complexity and better performance.

Refer Client side and server side programming for more information.

Regards,
Ajay

Ravi T · ‎01-26-2019

Hi Prabhmeet,

Did you try the code?