- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2023 10:18 AM
What is the use of sys_attachment_doc table.
when I trying to copy attachment from ritm to sc_task I found a code in community where they copied attachment to both sys_attachment table and sys_attachment_doc table.
*Can anyone explain me this
link to community post of copy sc_task attachment to sc_req_item.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2023 10:39 AM
Hi,
The sys_attachment table contains the meta data about the attachment files and the sys_attachment_doc table contains the actual file data.
"When you store an attachment to any table, a record is created in the Attachment [sys_attachment] table that contains attachment metadata. The file data is stored in the Attachment Document [sys_attachment_doc] table, in 4k chunks. For example, if you attach a 12k file called My_attachment.pdf, then there is an Attachment entry with three related Attachment Document entries."
https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/form-administr...
Regards,
Niklas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2023 10:39 AM
Hi,
The sys_attachment table contains the meta data about the attachment files and the sys_attachment_doc table contains the actual file data.
"When you store an attachment to any table, a record is created in the Attachment [sys_attachment] table that contains attachment metadata. The file data is stored in the Attachment Document [sys_attachment_doc] table, in 4k chunks. For example, if you attach a 12k file called My_attachment.pdf, then there is an Attachment entry with three related Attachment Document entries."
https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/form-administr...
Regards,
Niklas