Task for retrieving attachments for a dynamically linked list

Please advise why empty objects are being returned?
(Task related to retrieving attachments from associated request task records)

const current = new SimpleRecord(‘itsm_request’);
current.get(‘171794429198975961’);

const requestTask = new SimpleRecord(‘itsm_request_task’);
const attachment = new SimpleRecord(‘sys_attachment’);
let docID = ;

requestTask.addQuery(‘request’, current.sys_id);
requestTask.query();
while (requestTask.next()) {
docID.push(ss.getDocIdByIds(current.sys_id, requestTask.sys_id));
};

attachment.addQuery(‘record_document_id’, ‘in’, docID);
attachment.query();
while (attachment.next()) {
ss.info(attachment.sys_id);
};

Hello :wave:\n\nThe getDocIdByIds(tableId, recordId) method takes the table ID as its first parameter, but you are passing the request ID.\n\nSolution: Change current.sys_id to requestTask.sys_db_table_id

1 Like