How to created related attachment related list on change request table that should contain the attachment attached on approval request

[rupali18]

I want to create the related list(Relationship) on change table as approval-attachment and it should shows the attachments attached while approving and rejecting the change request. 

[Ankur Bawiskar]

Hi,

attachments are added to sysapproval_approver records? can you share screenshots?

If yes then you would require to create relationship between sysapproval_approver and change_request table

Did you start on that?

Regards
Ankur

[rupali18]

yes I have created the relationship.
Below is the code written in relationship.

var queryString = "table_nameINchange_request^table_sys_idIN" + parent.getValue("sysapproval") +","+parent.getValue("sys_id");


//queryString="table_nameINsc_request,sc_req_item,sc_task^table_sys_idIN"+parent.getValue("sysapproval") +","+parent.getValue("sys_id");
var gr = new GlideRecord("change_request");
gr.addQuery("number", 'sysapproval');
gr.query();
while (gr.next()) {
queryString += "," + gr.sys_id.toString();
}
current.addEncodedQuery(queryString);

[Ankur Bawiskar]

Can you share configuration image?

[Ankur Bawiskar]

something like this

(function refineQuery(current, parent) {

	// Add your code here, such as current.addQuery(field, value);
	var queryString = "table_nameINchange_request^table_sys_idIN" + parent.getUniqueValue();

	// get the approval records for this CHG
	var app = [];
	var gr = new GlideRecord("sysapproval_approver");
	gr.addQuery("sysapproval", parent.getUniqueValue());
	gr.query();
	while(gr.next()) {
		app.push(gr.getUniqueValue());
	}

	current.addQuery(queryString).addOrCondition("table_sys_id" ,"IN", app.toString());

})(current, parent);

Regards
Ankur