order guide - identify attachments upload on order guide from the sys_attachment table

cnshum
Tera Contributor

Hi

 

I have a requirement to identify attachments uploaded on an order guide from the sys_attachment table. OOB, there is no available field to identify that this attachment belongs to an order guide. 

1 REPLY 1

Uncle Rob
Kilo Patron

You can't do it from the list.  You'd have to script it.
I believe Order Guides deposit attachments on the Request.  So you'd have to gather all attachments that were on a Request, then do lookups to see which of those have a value in the request table's order guide field.