Remove prefix from table name in sys_attachment table

[Nishant26]

Hi @Ankur Bawiskar ,

I need to update the attachment from record producer to the incident table form. I am seeing "ZZ_YY" prefix in the table name field on the sys_attachment" table. this is causing the error while executing the code. 

Here is the code: 

var gr = new GlideRecord('sys_attachment');

if(gr.get(producer.number_list)){ //attachment field name

    gr.table_name='incident';     //copy to table name

    gr.table_sys_id=current.sys_id;//copy to record sys_id

    gr.update();

}

I need to remove the prefix "ZZ_YY" from the table name field in the sys_attachment table. how can this be achieved.

Thanks!

[Nishant26]

I forgot to mention, the target table(u_abc) is in a scoped application and I have created the BR in the same scope.

Requirement is to copy the attachment from the record producer's attachment variable to the target table(u_abc) record once the record producer form is submitted. The attachment should be visible on the header of the target table's record.

I have used the same script in an After insert BR as it has been mentioned by you, but it is not working.

[Ankur Bawiskar]

@Nishant26 

The same logic has worked earlier so it should work fine now as well.

Did you create Async insert BR?

Please share your script and BR configuration as well.

[Nishant26]

Yes, BR is async insert and here 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();

        gr.update();

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

    }

})(current, previous);

[Ankur Bawiskar]

@Nishant26 

Did you debug BR and see if BR triggered?

If the IF condition got satisfied or not

[Nishant26]

BR is working and attachment is also getting copied on the Record form but at the same time, it is creating two records in the sys_attachment table for the same u_abc table record, one with "ZZ_YY" prefix and one without the prefix.