question Re: Checking for attachments in Service Management forum

Checking for attachments

Samuel Macedo — Thu, 25 Jul 2019 17:21:59 GMT

Greetings everyone,

I have the following problem.

I got one type of record that needs to be filled with specific attachments. So I made a section in the form with "File Attachment" fields because i need to keep track of which file was attached and which wasn't.

Something like this.

I managed to make a Business Rule that checks if there are attachments missing, if so, it shows a message at the top of the screen saying "The following files are missing: " and it shows which ones are missing.

The problem is, if I attach a file, update the record and then remove the file, the form won't recognize that a file is missing anymore.

I don't understand why it does that.

Can someone help me? Tell me if you need more info.

Re: Checking for attachments

Allen Andreas — Thu, 25 Jul 2019 17:24:37 GMT

Well, we have no information about your business rule...other than you have one. So a screenshot of the settings and/or script and all that would be a start.

Thanks!

Re: Checking for attachments

AshishKM — Thu, 25 Jul 2019 17:31:19 GMT

Hi Samuel, how you are managing attachment type via business rule, business rule can check the file attached/or not attached for any records. Please share more information for your custom file type and business rule code.

Re: Checking for attachments

AlokD6499012040 — Thu, 25 Jul 2019 17:43:40 GMT

Hi Samuel,

I believe you are using the Business rule as only on insert not on update, and that is the only reason that when you create/insert the record the business rule is triggered and checks for the attachment but when it is updated the business rule is not triggered.

Please check the update check box as true in your business rule.

Please mark my answer as correct/helpful based on the impact.

Regards,

Alok

Re: Checking for attachments

Samuel Macedo — Thu, 25 Jul 2019 18:14:58 GMT

Sorry about that! I should've done that haha

I made a OnDisplay Business Rule with the following script:

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

// Add your code here
if (current == null) // to prevent null pointer exceptions.
return;

var PE = current.u_file_attachment_7;
var NF = current.u_file_attachment_4;
var RA = current.u_file_attachment_2;
var RC = current.u_file_attachment_8;

if(PE=="" || NF=="" || RA=="" || RC==""){
gs.addErrorMessage("Missing the following files: ");

if(PE==""){
gs.addErrorMessage(PE.getLabel());
}

if(RC==""){
gs.addErrorMessage(RC.getLabel());
}

if(RA==""){
gs.addErrorMessage(RA.getLabel());
}

if(NF==""){
gs.addErrorMessage(NF.getLabel());
}
}

Re: Checking for attachments

Samuel Macedo — Thu, 25 Jul 2019 18:18:18 GMT

I made a OnDisplay Business Rule that checks if each field is empty or not.

I don't know if there's a better way to do that.

This what I wrote:

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

// Add your code here
if (current == null) // to prevent null pointer exceptions.
return;

var PE = current.u_file_attachment_7;
var NF = current.u_file_attachment_4;
var RA = current.u_file_attachment_2;
var RC = current.u_file_attachment_8;

if(PE=="" || NF=="" || RA=="" || RC==""){
gs.addErrorMessage("Missing the following files: ");

if(PE==""){
gs.addErrorMessage(PE.getLabel());
}

if(RC==""){
gs.addErrorMessage(RC.getLabel());
}

if(RA==""){
gs.addErrorMessage(RA.getLabel());
}

if(NF==""){
gs.addErrorMessage(NF.getLabel());
}
}

Re: Checking for attachments

AlokD6499012040 — Thu, 25 Jul 2019 18:23:01 GMT

you can give a try with before-insert- update Business Rule instead of display business rule,

Also,

you can refer to the below link:

https://community.servicenow.com/community?id=community_question&sys_id=247fbaa9db58dbc01dcaf3231f96190c&view_source=searchResult

Re: Checking for attachments

Samuel Macedo — Mon, 05 Aug 2019 13:32:40 GMT

So... what I found out was that the File Attachment Field is a mess.

When the field is empty for the first time, it is ACTUALLY empty, so you can use the business rules condition like "IF FIELD IS EMPTY" and it'll work.

The problem is, when you upload a file and then delete it, the field doesn't become empty again. Instead it deletes the file from sys_attachment table (as expected) but the field itselft stays with the value of the sys_id of the last file (don't ask me why).

So I had to make a Insert/Update business rule with a script that searches for the sys_id of the file on the sys_attachment table, like this:

var att = new GlideRecord('sys_attachment');
    att.addQuery('sys_id',current.u_file_attachment_1);
    att.query();
    if(att.getRowCount()>0){
        current.setValue('u_choice_1','true');
    }else{
        current.setValue('u_choice_1','false');
    }

Then I had to make an onDisplay business rule to see if the 'u_choice_1' is true or false. If it's false, it shows a message saying that the file is missing.

Thanks for the help everyone.

Re: Checking for attachments

Allen Andreas — Mon, 05 Aug 2019 13:35:58 GMT

Glad you got it resolved!

Re: Checking for attachments

Ajay37 — Fri, 08 Jan 2021 12:34:08 GMT

Hi @Samuel Macedo ,

Hope you are doing good.

I have used this script for my requirement and it is working good for showing messages. But, when I delete the attachment from the field, and saving the form it is not showing the message even document field is empty. Could you please help me on this?

Thanks