this worked for me
CHG -> has 1 file
Approval record has 1 file
Total 2 records shown in related list
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
// get the approval records for this CHG
var app = [];
var gr = new GlideRecord("sysapproval_approver");
gr.addQuery("sysapproval", parent.getUniqueValue());
gr.addQuery("source_table", "change_request");
gr.query();
while(gr.next()) {
app.push(gr.getUniqueValue());
}
app.push(parent.sys_id.toString());
current.addQuery("table_sys_id" ,"IN", app.toString());
})(current, parent);
Please mark my response as correct and close the thread
Regards
Ankur
Hi Ankur,
It is working. Thank you.
I have another one doubt or issue,
if we use the glidesysattachment.copy method to copy attachment it creates the duplicate records so we prefer the related list solution.
Earlier
I was trying to copy the attachment using glidesysattachment.copy() and then I am comparing with the attachment table , but in the code if we provide specific file name then only the code gets run otherwise not.
Below is the code I am running on approval table:
If I comment the line - gr.addQuery('file_name','testdata.txt'); then creates the duplicate file on change record
Hi,
There is OOB relationship for change and related approver.
Configure this from change request form.
Mark this as Correct/Helpful in case this helps you in anyways.
Regards,
Sourabh
