Trying to get sys id from Attachemnt table sys id

[sanjeet1245]

(function executeRule(current, previous) {
    try {
      


gs.info("-------------------------111111111111111111");
            var attachment = new GlideSysAttachment();
            var attachmentContent;
            gs.info("---------------------222222");
           var agr = new GlideRecord('sys_attachment');
		   agr.addQuery('table_name','incident');
		   agr.addQuery('table_sys_id',current.sys_id);
		   agr.query();
           gs.info("-----------------333");

            while (agr.next()) { 
			gs.info('Attachment sys_id:' + agr.getValue('sys_id'));
			
                gs.info('-------' + agr.getValue('file_name')); //print file name of attachment
                attachmentContent = attachment.getContent(agr);
                gs.info('------Attachment content: ' + attachmentContent); //print attachment content
			
            }
        }catch(e){gs.info('------------error in xml attachment '+e);}
})(current, previous);

  Hi, i am having an issue with my business rule. in my business rule on sys_attachment table on condition filename is anything . when i add and save any attachment in the incident form ,i want to see the details of the attachment table sys id in system log 

[Alka_Chaudhary]

Hello @sanjeet1245 ,

You can use the below script to get the details of attachments in system log:-

var attachment = new GlideSysAttachment();

var agr = attachment.getAttachments('incident', current.sys_id); //create attachment GlideRecord

while(agr.next()) { //for each attachment on the incident record
   gs.info(agr.getValue('file_name')); //print file name of attachment
   var attachmentContent = attachment.getContent(agr);
   gs.info('Attachment content: ' + attachmentContent); //print attachment content
   gs.info('Attachment content type'+agr.getValue('content_type'));
}

Attachment content will be displayed as undefined because of scope issue. You can refer to this article for attachment content issue KB0952918. For more information related to attachment you can refer to this documentation LINK.

If this response clears up your doubt, kindly flag it as both helpful and correct.

Thanks,

Alka

[sanjeet1245]

my business rule is  on sys_attachment table . my gs.log(-----------3) is getting printed on system log but after the while (agr.next())  loop part in not getting printed in system log .

my requirement is while loop part printed in the system log which i want to print but instead of printing output its show undefined or not print any message.

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


gs.info("-------------------------111111111111111111");
            var attachment = new GlideSysAttachment();
            var attachmentContent;
            gs.info("------------22222222222222222222222");
            var agr = attachment.getAttachments('incident',  current.sys_id); //create attachment GlideRecord
gs.info("---333333333333333333333333333333333333333333");

            while (agr.next()) { //for each attachment on the incident record
            gs.info('------------44444');
                gs.info(agr.getValue('file_name')); //print file name of attachment
             var attachmentContent = attachment.getContent(agr);
                gs.info('Attachment content: ' + attachmentContent); //print attachment content

		   
		    }

        }catch(e){gs.info('------------error in xml attachment '+e);}


        })(current, previous);

[Alka_Chaudhary]

Attachment content will be displayed as undefined because of scope issue. You can refer to this article for attachment content issue KB0952918 .

[sanjeet1245]

Still Not Working 

[Alka_Chaudhary]

Create business rule in any custom application scope (except global) then try it. It should work.