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 

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

    }  

[KaustubhS]

According to the whole conversion. I think this is the final working script. So have you added this script in the script section of the RP or used as a BR. If used as a BR what's the "when to run" condition you have used". Can you please help me on this

[Sampathr382]

Hi @Ankur Bawiskar,

Thank you for the post about removing ZZ_YY prefix from the attachment name.
I have tired this for one of the requirement for attachment variable in catalog item.

The solution is working whenever we attach/upload one file for attachment variable. But, it's not working whenever we replace the attachment with another one it's not working. I mean the first attachment is getting updated in request instead of second/latest attachment.

Can you help me on this?

[Ankur Bawiskar]

@Sampathr382 

can you post a new question for this and tag me there?

share all the details, screenshots script etc there