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

[Sneha_Krishna1]

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?

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

Thanks

@Ankur Bawiskar 

[Ankur Bawiskar]

@Sneha_Krishna1 

Glad to know.

Please mark my response as correct and close the thread.

[Sneha_Krishna1]

@Ankur Bawiskar 

I have already marked your solution as helpful.

[Ankur Bawiskar]

@Sneha_Krishna1 

Please mark it as correct answer as well and close the thread.

[Imam Pasha]

Hi Ankur,

I am also using the same code but For me the attachment is showing twice in the header.

Below is the code.

(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();

        new global.VariableUtil().copyAttachment(gr.sys_id, current.getTableName(), current.sys_id);

        gr.update();

    }

})(current, previous);

[Imam Pasha]

I tried with The below code and its is working as expected.

 // Add your code here

   var attach = new GlideRecord('sys_attachment');

    attach.addQuery('table_name', 'ZZ_YY' + current.getTableName());

    attach.addQuery('table_sys_id', current.sys_id);

    attach.query();

    if(attach.next()){

        attach.table_name = current.getTableName();

        attach.update();

    }