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]

I think Im missing something in my Client script:

When I press the OK button before the email client is going to open, nothing is happening..

[Miran Alam]

I think Im missing something in my Client script:

When I press the OK button before the email client is going to open, nothing is happening..

[Rob Sestito]

And this is how I have my BR (I saw your comment that says to "change the table name accordingly and query as well based on table selected"). So, I did so in effort to make sure it is hitting the Core HR Case Table. Let me know if you see what I changed is wrong, and possible giving my my issue.

(function executeRule(current, previous /*null when async*/) {
	
	// Add your code here
	var case_number = current.instance.number.toString();
	var gr = new GlideRecord('sn_hr_core_case');  //Change the Table Name accordingly and query as well based on table selected
	gr.addQuery('number',case_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_via_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);

Could any of the issue be at how the core hr case table extends to all other hr case tables?

[Andrew Parkes]

Hi Shloke,

Thanks for your very helpful replies here.

I've tried using this updated BR but all the attachments are still adding to the email client.

Have you any ideas?

[Miran Alam]

Hi,

I can't get the email client to open. I have checked that the email client. = true in dictionary also 😕 

Can you please help me with this