sys_id of attachment

Deepthi13
Tera Expert

Hi team,

i am trying to assign attachment sys_id in to a string field, in "insert business rule on signature_image" table.

I am getting @@@@@1 , @@@@@2 , logs only, i am getting sys_id of the attachment in @@@@@2 log, but not updating in to that field

(function executeRule(current, previous /*null when async*/) {
// Add your code here
gs.log('@@@@@ABC ');
var request = new GlideRecord('sc_request');
request.addQuery('sys_id',current.document);
request.query();
if(request.next()){
gs.log('@@@@@1 ABC number '+ request.number);
gs.log('@@@@@2 ABC sys id '+current.getUniqueValue());
var id = attachementid();
if(id == 'NOValue'){
gs.log('@@@@@3'+u_current_attachment_sysid);
request.u_current_attachment_sysid = u_current_attachment_sysid;
request.update();
id = attachementid();
}
if(id != 'NOValue') {
gs.log('@@@@@4'+u_current_attachment_sysid);
request.u_current_attachment_sysid = id;
request.update();
}
}
function attachementid(){
var attachment = new GlideRecord('sys_attachment');
attachment.addQuery('table_sys_id', current.getUniqueValue());
gs.log('ABC jaifdiadsf');
attachment.query();
gs.log('@@@@@5'+u_current_attachment_sysid);
if(attachment.next()){
gs.log('@@@@@6'+u_current_attachment_sysid);
return attachment.sys_id;
}
else
gs.log('@@@@@7'+u_current_attachment_sysid);
return 'NOValue';
}
})(current, previous);

 

1 ACCEPTED SOLUTION

Hello Deepthi,

 

Could you please mark the answer as correct as we will not leave this thread unanswered

 

Regards,

Chalan

View solution in original post

31 REPLIES 31

You should be able to do that ..!!

if you could write the BR then you can also write background script

left nav --> scripts - background

 

find_real_file.png no it is not there

Try by replacing with your instance name
https://<yourinstance>.service-now.com/nav_to.do?uri=%2Fsys.scripts.do

thx.. pls find below response, it is not going inside if,,, in BR also i am facing same issue

if(attachment.next()){
gs.print('@@@@@4'+attachment.sys_id.toString());
return attachment.sys_id.toString();
}

find_real_file.png

Can you give the screenshot of background script along with the sys_id you have given?