How can i get attachment data in table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2022 11:05 AM
Hi All,
My requirement is, once user attached the attachment and RITM submitted i need to add attachment data custom table. how can i develop import set and transform map for this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2022 12:01 PM
the sc_req_item table contains the requested items records. And the attachments are stored in sys_attachment, and the sys_attachment_doc table (I see a sys_attachment_doc_v2 table in my instance but it is empty). I do not think you want to use and import set and transform map as the data resides in the instance database. A Business Rule can be defined on the sc_req_item table, that can query the records in the attachment tables and then use the results to copy the attachment to the custom table.
You can query the sys_attachment table using the 'table_name' and 'table_sys_id' with 'sc_req_item' and the sys_id of the record that was created/updated in the sc_req_item table.
You can query sys_attachment_doc using the 'sys_attachment' field containing the sys_id of the sys_attachment record.
Some references:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2022 01:47 PM
See:
for an easier way to copy attachments.
