Disable ZZ_YY prefix from attachment when added through record producer

Chenab Khanna · ‎02-11-2021

Hi,

I have a 'attachment' type variable in my record producer which i have made mandatory. When the user uploads any attachment, i want the attachment to get saved in the record created. But instead, it is hiding it.

I can see the entry created in sys_attachment but under table name field, a prefix ZZ_YY is getting added which is making the attachment hidden.

Please find the field below -

Record in sys_attachment -

Can anyone help me get this attachment added in the record as it happens when add any attachment from here -

Ankur Bawiskar · ‎02-11-2021

@Chenab Khanna

This worked well for me

1) I created Async After Insert BR on the target table

2) Script as this

a) Remove the ZZ_YY

b) Then use the Copy Attachment

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

	// Add your code here
	var gr = new GlideRecord("sys_attachment");
	gr.addQuery("table_name", "ZZ_YY" + current.getTableName());
	gr.addQuery("table_sys_id", current.sys_id);
	gr.query();
	if (gr.next()) {
		gr.table_name = current.getTableName();
		gr.update();
		new global.VariableUtil().copy(gr.sys_id, current.getTableName(), current.sys_id); 
	}

})(current, previous);

Output:

1) The file added to the record

2) The file present on the attachment variable

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎02-25-2021

Hi,

Can you try for some other table or record producer

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Chenab Khanna · ‎02-25-2021

You mean create record in another table instead of x_eyit2_bo_journal_entry_data_mapping or create this BR on another table?

Ankur Bawiskar · ‎02-25-2021

the record producer is on which target table?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

asifnoor · ‎02-14-2021

Try this code.

var attachment = new GlideRecord('sys_attachment');
attachment.addQuery('table_name',current.getTableName());
attachment.addQuery('table_sys_id',current.sys_id);
attachment.query();
if(attachment.next()){
gs.info("code working right ");
var gr = new GlideRecord('x_eyit2_bo_journal_entry_data_mapping');

gr.initialize();
gr.u_journal_header = current.sys_id;
gr.setValue('u_status','ready');

var newRecord = gr.insert();

GlideAttachment.copy(current.getTableName(),current.sys_id,gr.getTableName(),newRecord());
}

Mark the comment as a correct answer and helpful if this helps to fix the issue.

Chenab Khanna · ‎02-25-2021

Hi @asifnoor the above code doesn't seem to work. I am unable to get the info message, however the query works fine.