Add Attachment Automatically from Idea to Demand to Story table.

[Baker1]

Hi Team,
I need to Add Attachment automatically from idea to demand to story.
can Someone please help me.

[Dr Atul G- LNG]

Hi @Baker1 

These 2 links will be helpful

https://www.servicenow.com/community/developer-forum/retain-attachment-on-idea-record-when-creating-...

https://www.servicenow.com/community/itsm-articles/copying-attachment-from-one-record-to-another-rec...

[Dileep Raju]

Hi @Dr Atul G- LNG 
thank you for quick reply
Code is not working as expected

(function executeRule(current, previous /*null when async*/) {

    var dmnd = new GlideRecord('dmn_demand');
    dmnd.addQuery('sys_id', current.task);
    dmnd.query();
    
    while (dmnd.next()){
        var ideaAttach = new GlideRecord('sys_attachment');
        ideaAttach.addQuery('table_sys_id', current.sys_id);
        ideaAttach.query();
        
        while (ideaAttach.next()){
            ideaAttach.table_sys_id = dmnd.sys_id;
            ideaAttach.table_name = 'dmn_demand';
            ideaAttach.update();
        }
    }

})(current, previous);

[Dr Atul G- LNG]

Sorry mate, I am not strong in coding 😞