The solution I chose was to create a related list on the child that shows the parent's attachments as well as all sibling attachments, and then on the parent's record you can use the list to see all the children's attachments.
To make these lists you have to go to System Definition>Relationships and make sure the "queries from" is sys_attachment but in the code you have to reference what table you want it to look for others on... for example here is mine for sc_task and I have a different relationship defined for each type of form this Relationship will be shown on:
(function() {
var csfam = commaSeparatedTaskFamily('sc_task',parent.sys_id);
current.addQuery('table_sys_id', 'IN', csfam);
})()
All the relationships call this same Script Include:
function commaSeparatedTaskFamily(fromtable, recid){
var family = ''; //output a comma-separated string of related sys_ids
//STEP 0 finding nucleus/source/starting point
var gr = new GlideRecord('task');
if (fromtable == 'sysapproval_approver'){
var aprv = new GlideRecord('sysapproval_approver');
aprv.get(recid);
gr.get(aprv.sysapproval); //record being approved is the source record
family += (gr.sys_id + ', ');
}
else
gr.get(recid); //initiating record is the source record
//STEP 1 up & across
if (gr.parent){
family += (gr.parent + ', ');
var pfind = new GlideRecord('task');
pfind.get(gr.parent);
while (pfind.parent){ //parent-grandparent-great grandparent-infinity
family += (pfind.parent + ', ');
pfind.get(pfind.parent);
}
if (fromtable != 'sysapproval_approver' && fromtable != 'pm_project_task'){ //look for siblings, unless an Approval or Project Task
var sfind = new GlideRecord('task');
sfind.query('parent',gr.parent);
while (sfind.next()){
if (sfind.sys_id != gr.sys_id) //don't want it finding itself
family += (sfind.sys_id + ', ');
}
}
}
//STEP 2 down & down
var cfind = new GlideRecord('task');
cfind.query('parent',gr.sys_id);
while (cfind.next()){ //add children
family += (cfind.sys_id + ', ');
var gcfind = new GlideRecord('task');
gcfind.query('parent',cfind.sys_id);
while (gcfind.next()){ //add grandchildren
family += (gcfind.sys_id + ', ');
//rarely used great grandchildren, decreased performance if enabled!
/*var ggcfind = new GlideRecord('task');
ggcfind.query('parent',gcfind.sys_id);
while (gccfind.next())
family += (ggcfind.sys_id + ', ');*/
}
}
return family;
}
And this is how it looks on the RITM form showing the Catalog Task's (child) Attachments:
Also wanted to link all the attachments in the email notifications so the templates just have ${mailscript:attach_links} and this is the mail script I used:
attachLinks();
function attachLinks() {
var rectype = '';
var gr = new GlideRecord('sys_attachment');
//APPROVALS DONT HAVE CLASS NAMES
if (!current.sys_class_name && current.source_table && current.source_table == 'sc_task' || current.source_table == 'sc_req_item')
rectype = 'sysapproval_approver';
else if (current.sys_class_name == 'sc_req_item')
rectype = 'sc_req_item';
//FOR CATALOG ITEMS/TASKS THEMSELVES
if (rectype != ''){
var csfam = commaSeparatedTaskFamily(rectype,current.sys_id);
var famarray = csfam.split(',');
var hgr = gr.addQuery('table_sys_id',famarray[0]); //first record's attachments
for (var i=1; i<famarray.length; i++){
hgr.addOrCondition('table_sys_id',famarray[i]); //then gets the rest
}
}
//FOR ALL OTHER RECORDS THAT WILL ONLY ATTACH APPROVAL'S ATTACHMENTS
else {
gr.addQuery('table_sys_id',current.sys_id);
}
gr.query();
if(gr.hasNext()){
template.print("Attachments: ");
while (gr.next()) {
var attachLink = '<a href="' + gs.getProperty("glide.servlet.uri") + gs.generateURL(gr.getTableName(),gr.sys_id) + '">' + gr.file_name + '</a>';
template.print(attachLink);
if(gr.hasNext())
template.print(", ");
else
template.print("\n");
}
}
}
Even sabell2012 might be impressed with this... not as elegant as some of his code but he can make it work
