Where the attachment gets stored if we are not placing the order?

[ranabiswas]

Hi Everyone,

While ordering an item from service catalog, I have come across a scenario which to me seems a little unusual. What I was doing is - I was attaching an attachment to the item that I intended to order, the attachment is getting stored in the sc_cart_item table with a table sys_id, however the table sys_id is not that of sc_cart_item. More over, I didn't find any table with that particulat sys_id. So my question is where exactly this attachment is getting stored? I don't have an RITM number here, so from where this attachment can be retrieved.

Could anyone please clarify this.

Thanks in advance.

Regards,

Rana

[Ziaur Rahman1]

Hi Rana,

It get stored in 'sys_attachment_doc' table and information of the attachment like size, file name etc. get stored in sys_attachment table.

Please follow the below given link.

Attachments in ServiceNow

Thanks

Ziaur Rahman

Please mark correct if it is helpful.

[ranabiswas]

Hi Ziaur,

Thanks for your answer, however my question is - when I attach any attachment in the cart, the attachment is getting stored in the cart table, but after placing the order the same attachment gets stored in the RITM itself. Could you please tell me exactly how is mapping process is done?

Regards,

Rana

[Ziaur Rahman1]

Hey Rana,

If the question is this how attachment is copied from Request to RITM then I am sure that it is mapping through business running on the request item table with the following code

copyAttachment();  

•  
• function copyAttachment() {  
•   var reqItem = new GlideRecord('sc_req_item');  
•   reqItem.addQuery('request', current.sys_id);  
•   reqItem.query();  
•  
•   while (reqItem.next()) {  
•             GlideSysAttachment.copy('sc_req_item', reqItem.sys_id, 'sc_request', current.sys_id);  

If I am wrong to understand your question then please try to re-explain it.

Thanks

Ziaur Rahman