Select specific attachments to copy

Rob Sestito · ‎08-12-2019

Hey SN Comm,

I have a couple of things that I want to see if they can be enhanced. For my first one, we have a UI Action that grabs the attachments from the HR Case, and posts them to the HR Task: (this is in production)

GlideSysAttachment.copy(current.parent.sys_class_name, current.parent, current.getTableName(), current.sys_id);

current.update();
action.setRedirectURL(current);

gs.addInfoMessage("Attachments have been added!");

gsftSubmit(null, g_form.getFormElement(), 'sysverb_update_and_stay');

Then, I have a Business Rule to do the following (which is NOT in production yet): This BR automatically allows the case worker, to have the attachments added to the email (from email client) from the Case/Task (depending on which table I give as the target).

(function executeRule(current, previous /*null when async*/) {
	//gs.log('M in loop');
	
	// Add your code here
	var lookatt=new GlideRecord('sys_attachment');
	lookatt.addQuery('table_sys_id',current.instance);
	lookatt.query();
	while(lookatt.next())
		{
		//	gs.log('M in loop again');
		GlideSysAttachment.copy('sn_hr_core_case_operations', current.instance, 'sys_email', current.sys_id);
	}
})(current, previous);

I really want to see if there is a way, at least for the UI Action,'Grab Attachments', to make my options selectable. I think it would be really beneficial to be able to do that with these features.

Anyone able to see/or know if this is possible at all?

Thanks in advance!

-Rob

shloke04 · ‎08-26-2019

Hi Rob,

Yeah I was able to replicate the issue in my Personal Development instance as well. Took me a while and have updated the Business Rule. Just update your Business Rule as per the script mentioned below.

(function executeRule(current, previous /*null when async*/) {
	
	// Add your code here
	var tic_num = '';
	var sub =  current.subject;
	var number = sub.replace(/[^\d.]/g,'');//current.subject.toString().substr(0,10);
	var num = number.substr(0,7);
	var num2 =sub.indexOf(num);
	if(num2 > 3)
	   tic_num = sub.substr(num2-3,num.length + 3);
	else
	  tic_num = sub.substr(0,num.length + num2);
	var ticket_number = tic_num.replace(/\s/g,'');
      // The first 14 characters of the subject are the ticket number. 
      // We need to subtract this number to get the sys_id of the task record.

     var gr = new GlideRecord('incident');  //Replace with your Table Name from which you want to copy to Email Client
     gr.addQuery('number',ticket_number);
     gr.query();
     gr.next();
     
     var arrayAttachment = GlideSysAttachment.copy(gr.sys_class_name, gr.sys_id ,'sys_email', current.sys_id);

     for (var i = 0; i< arrayAttachment.size(); i++) { 
             var attachmentSidsPiece = String(arrayAttachment.get(i)).split(',');
             var sourceAttachmentSysid = attachmentSidsPiece[0];
             var targetAttachmentSysid = attachmentSidsPiece[1]; 
             var sourceRec = new GlideRecord('sys_attachment');
             var targetRec = new GlideRecord('sys_attachment');

     if (sourceRec.get('sys_id',sourceAttachmentSysid) &&       
                               targetRec.get('sys_id',targetAttachmentSysid)) {

       if (sourceRec.u_send_to_email_client==false) {
            //delete all other attachments that are not marked to send via the email client        
            targetRec.deleteRecord();

     } else { //reset the flag
           sourceRec.u_send_to_email_client= false;
           //as soon as the email record is created, reset the flag to false again
           sourceRec.update();
    }
 }
}
	
})(current, previous);

Rest of the code remains the same. Hopefully this time it should work:)

Please let me know if still there is an issue and we can check further.

Hope this help. Please mark the answer as helpful/correct based on impact.

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

Rob Sestito · ‎08-26-2019

This works for the UI Action - to show up ONLY when two conditions are met. Current user ID IS Assigned To person, and current record HAS attachments.

Brian Lancaster · ‎08-26-2019

I created a script include with the following code.

var emailClientEnabled = Class.create();
emailClientEnabled.prototype = Object.extendsObject(AbstractAjaxProcessor, {

	emailClient: function(tableName){
		var gr = new GlideRecord ('sys_dictionary');
		gr.addQuery('type', 'a0e0cbd2c3203000bac1addbdfba8f59');
		gr.addQuery('name', tableName);
		gr.query();
		if (gr.next()){
			if (gr.attributes.indexOf('email_client=true') > -1){
				return true;
			}
			else {
				return false;
			}
		}
		else {
			return false;
		}
	},
	
    type: 'emailClientEnabled'
});

Then I made my condition as below as I cannot restrict which ITIL users can send the attachments.

current.hasAttachments() && new emailClientEnabled.emailClient(current.table_name) == true

Rob Sestito · ‎08-26-2019

Very nice! It makes much more sense for you to handle yours that way. Our HR Cases are on the more restricted side. So we would only want the Assigned To person handling this. Thanks for the info Brian!

Rob Sestito · ‎08-26-2019

Hey Shloke,

I know we closed this - but I totally forgot about the other part to my original post question. Are you able to lend a hand with that part also?

Basically, I want to be able to do the same exact thing, but here - I just want the user to be able to select from the attachments that are on the parent HR Case, and copy them to the HR Task. I have that UI Action (above in my original post), that does a one-off and copies all of them. But, I wanted to make it so they can be selectable.

Are you able to help - and would you prefer me to create a new post and direct you to it?

Cheers bud!

-Rob

Rob Sestito · ‎08-27-2019

I ended up creating a new post for the additional help I needed.

Post is here: Selecting which attachments to copy from one record to another

Hope you can help 🙂

Cheers!

-Rob