How to check if HR case has attachment

[Pearl3]

Our HR wanted to check if HR case has attachment.

I created a field "u_has_attachment" on the table and a business rule to that uses function hasAttachment. However, this function is cannot be used on a scoped application. HI Support suggested we create our custom script to make this possible. 

Is there any way that we can check if HR cases has attachment?

[Mark Roethof]

Hi there,

You could set up a GlideRecord query, to query the sys_attachment table. Just an IF query, with setLimit(1), if there's result, you have an attachment.

Would that be something?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Mark Roethof]

For example:

var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_name', current.getTableName());
gr.addQuery('table_sys_id', current.getUniqueValue());
gr.setLimit(1);
gr._query();

if(gr._next()) {
	//Your code goed here
}

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Pearl3]

Thank for your response, but the purpose is to set the custom field set to true if there is an attachment on the hr case. Because we are planning to use the field for reporting purposes.

[Mark Roethof]

So then you could use this code or something similar in an update Business Rule, to update your case? That matches what you described as requirement.

Or alternative (just tested, works):

A async on insert business rule on sys_attachment:

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

	var gr = new GlideRecord(current.getValue('table_name'));
	gr.addQuery('sys_id', current.getValue('table_sys_id'));
	gr._query();

	if(gr._next()) {
		gr.setValue('u_has_attachment', true);
		gr.update();
	}

})(current, previous);

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list