How to add attachment on the HR case using catalog attachment variable type?

Sneha_Krishna1
Tera Contributor

Hi,

Hope you are doing well.

I have an 'attachment' type variable in my record producer. 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 not on case,

How can I remove ZZ_YY before copying. I written this business rule 

Async - insert. it's not working. can you help?

 

Sneha_Krishna1_0-1694526754824.png

 

 

If I remove this zz_yy from sys_attachment manually from the table then it's adding the attachment on the case.

Sneha_Krishna1_1-1694526754823.png

 

Thanks

@Ankur Bawiskar 

23 REPLIES 23

It's not showing on the top in the attachment header. I want this "test file.txt" on the top.

it's not showing in the attachments tab. can you please help me on this 

Sneha_Krishna1_0-1694623803132.png

 

 

 

This is working for me. Thank you so much.

@Sneha_Krishna1 

Glad to know that my script worked.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Hi @Ankur Bawiskar 

 

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

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();
new global.VariableUtil().copyAttachment(gr.sys_id, current.getTableName(), current.sys_id);
gr.update();
}

 

It's not working. can you correct it if I'm missing something?

 

Thanks,

@Sneha_Krishna1 

give business rule as Async insert

You said it's working fine earlier.

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