Copy custom variable in record producer to OOTB record producer attachment

[ronro2]

Hey! 

In a record producer I have a custom variable of type attachment called 'bifoga_fil':

So I want to copy this to the OOTB attachment on the record producer in the back-end, so that the attachment is visible in the banner above and in the logs. 

I've marked what I mean with red. 

So, I am thinking an after insert business rule of some kind? What would that look like? 

I'm thankful for your help. 

All good, 

[ronro2]

@Ankur Bawiskar It did work! I had before put in the parent table, but when I put the specific child table that the record producer communicates to it worked! 🙂 Thank you so so much! 

[Rakesh_M]

Hi @ronro2 ,

1. Open the sys_attachment table records.

2. Check that the Table Name for the recently uploaded attachments is x_vgll_rail_task.

3. Ensure it is not prefixed with ZZ_YY (e.g., it should not be ZZ_YYx_vgll_rail_task).

[ronro2]

@Rakesh_M this is what I see: 

[ronro2]

@Ankur Bawiskar I realised your solution is either or. So If I want it to show in the log, I must refer to the parent table. If I want it to show in the banner I must refer to the child table in for this script: 

new global.VariableUtil().copyAttachment(producer.<variableName>,'<tableName>', current.sys_id);

In my case I need both.. so to show the attachment both in the log and in the banner of the record... So your solution is almost there but not quite there. 

[Ankur Bawiskar]

@ronro2 

your record producer is on which table?

Your requirement as per question is to add that file from attachment variable to target record

That's working as per my script?

what other thing is required?