Select specific attachments to copy

[Rob Sestito]

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

[Miran Alam]

Hi Rob, 
I have done everything like mentioned, When i'm clicking on OK before the email client is going to pop up. Nothing is happening.. 

[Brian Lancaster]

Hello shloke04,

I was just trying to implement this in my company instance and seems that there is a missing peace of code in the HTML section of you UI Page.  I found it in my PDI.  It is in the for look after the else if.  The following line is missing.

records1 = records1 + ',' + records[i];

[Brian Lancaster]

I have made some changes to make this usable for any table that can have the email client.  I have made changes to the UI action and the business rule.  I am just posting an enhancement so please do not change the correct answer.  

UI Acation: I change the table to Global and added a condition current.hasAttachments() so the condition now look like this: current.hasAttachments() && new emailClientEnabled.emailClient(current.table_name) == true

Business rule: I modified the code so it was not doing so a lookup on the subject to get the ticket number or having to do a lookup on the record to find the sys_id.

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

    // Add your code here
	var ticket_sys_id = current.getValue('instance'); //Get Ticket sys_id from record that created email.
	var table = current.instance.sys_class_name;  //Get table name from record that created the email
	
    // 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 arrayAttachment = GlideSysAttachment.copy(table, ticket_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);