Advanced Relationship Query

[davidwilhelm-in]

We have a parent table (x_datrp_maintenanc_parent_datalink_contract) and a child table (u_datalink_contract_item). The following relationship script allows me to display all related child records from the parent form by pulling all child contracts that have the same contract number, company, and coverage type manufacturer.

current.addQuery('u_dynamics_ax_contract_number', parent.getDisplayValue('u_insight_contract_number')).addCondition('company', parent.getValue('u_company')).addCondition('u_coverage_type_manufacturer', parent.getValue('u_manufacturer'));

Now I want to be able to display all attachments from the child table records, from the parent form. I know the table is sys_attachment.

I don't think I can create the same kind of "Query With" relationship since there are three tables involved. Do I need to create a custom query using an advanced relationship? Would I put the code in "query from"? Anyone have a code example of this?

Thanks

David Wilhelm

[amol_joshi]

This actually helped me in creating a new related list by filtering the records associated with records in an existing related list.

So I was basically talking to an existing related list instead of the "parent" to get the records into a new related list.

[amol_joshi]

var sysIDs = "";

var gr = new GlideRecord("incident");

gr.addQuery('problem_id.number', parent.getValue('number'));

gr.query();

while (gr.next()) {

sysIDs += ", " + gr.caller_id.sys_id;

}

current.addQuery("sys_id", "IN", sysIDs);

[davidwilhelm-in]

I'm trying to add a child relationship related tab on the parent form. In this way, the user will be able to see all of the attachments for the child contracts in the list, instead of having to click through hundreds of child contract records to find the attachment they are looking for.