Can we move attachment record thru update set or using any other method

[psjajda]

HI,

We have more than 100 records in table with attachments records added to them. Can we move or migrate those records from one instance (Dev) to Test instance except cloning ? If yes let me know how can we achieve it?

Pankaj

[Chuck Tomasi]

You could create a new (scoped application), go to the sys_attachment table, and mark those records you want (checkmark on the side), then go to the list UI action and select Create Application File. Go to System Applications> Applications, open your application, publish to an update set, mark the data as demo data, export to an update set, and you'll capture them just fine.

[SwarnadeepNandy]

Hi Chuck,

This will move only the "sys_attachment" record in update set, not the metadata of the attachment. We have to move the 'sys_attachment_doc' records pertaining to the sys_attachment record also.

So is there any easier way to create attachment in custom scope?

Regards,

Swarnadeep Nandy

[Chuck Tomasi]

You are correct. You would need to move both associated records from sys_attachment and sys_attachment_doc in the app. You can use Create Application File from the list menu on the related tables to get the record as part of your application set and update set(s).

[SwarnadeepNandy]

Hi Chuck,

But the UI Action "Create Application File" is not available in sys_attachment_doc table. So we cannot directly move it to the application set.

Regards,

Swarnadeep Nandy