sys_id of attachment

[Deepthi13]

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);

[Chalan B L]

Can you paste the code you are trying ??

i tried the logic in background script ..worked perfectly !!!

Regards,

Chalan

[Deepthi13]

below code,

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

var request = new GlideRecord('sc_request');
request.addQuery('sys_id',current.document);
request.query();
if(request.next()){

var signatureimagesysid = current.sys_id;
var id = attachmentSys_id(signatureimagesysid);
gs.log('@@@@@3'+id);
request.u_current_attachment_sysid = id;
request.update();
}

function attachmentSys_id(signatureimagesysid){
var attachment = new GlideRecord('sys_attachment');
attachment.addEncodedQuery('table_sys_id='+signatureimagesysid);
attachment.query(); //you are missing this line of code
if(attachment.next()){
gs.log('@@@@@3'+attachment.sys_id.toString());
return attachment.sys_id.toString();
}
}

})(current, previous);

[Chalan B L]

Which table you are writing this BR ??

what type of BR it is ???

[Deepthi13]

and 1 information to u i tried this in my personal dev before doing in company dev, it is working in personal dev with below coded but it is not working in company dev same code, plese find below screen shot for the type of BR

(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('ABC number '+ request.number);
gs.log('ABC sys id '+current.getUniqueValue());

var id = attachementid();
if(id == 'NOValue'){

id = attachementid();
}
if(id != 'NOValue') {
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();
if(attachment.next()){
return attachment.sys_id;
}
else
return 'NOValue';
}


})(current, previous);

// var image = new GlideRecord('signature_image');
// image.addQuery('document',g_form.getUniqueValue());
// image.query();
// if(image.next()){
// alert('@@@insidewhile');
// var attachment = new GlideRecord('sys_attachment');
// attachment.addQuery('table_sys_id',image.sys_id);
// attachment.query();
// g_form.addErrorMessage('thisistest1'+attachment.sys_id);
// if(attachment.next()){
// g_form.setValue('u_current_attachment_sysid',attachment.sys_id);
// }

[Omkar Mone]

Hi 

You didnt query the table. and i see tostring() like this. use toString().

Mark correct answer to close the thread. 

Reagards,

Omkar Mone.