The Now Platform® Washington DC release is live. Watch now!
03-10-2016 08:27 PM
How does the table kb_knowledge link to sys_attachment. I'm trying to get the sys id of the attachment that is on the kb_knowledge.
Solved! Go to Solution.
03-10-2016 10:23 PM
Hi Florence,
Write a business rule on the Knowledge table.
Inside script, write a Glide query to sys_attachment table.Like,
var attachment = new GlideRecord('sys_attachment');
attachment.addQuery('table_sys_id',current.sys_id);
attachment.query();
while(attachment.next()){
gs.addInfoMessage('sys_id of the attachment is : ' +attachment.sys_id);
}
Thanks,
Mihir
03-10-2016 08:58 PM
03-11-2016 10:57 AM
How do I find the sys_attachment table? I have a document that I need to find the sys id.
03-11-2016 08:39 PM
In the left navigation menu search box type sys_attachment.LIST and click enter.
Thanks,
Mihir
12-15-2020 02:51 PM
I have access to the sys_attachment table, but there's no correlation back to the KB article(s). How do I reverse search back to the KB article to see where the Attachment actually is in the KB? I want to instruct the Knowledge workers to STOP attaching monstrously large attachments.