Relationship Related List Script

[GemDev]

Hi all,

I am working a on a requirement whereby I have to add a related list to our Vendor form, showing what Risks have been raised again Vendor CI's. The Relationship is as follows and currently brings back all Risks:

Applies to table: core_company
Queries from table: u_risk_register

Our CI's are held on a table named - cmdb_ci_business_app. I am having a challenge in getting the correct script in order to do this, could someone assist on this please?

[Ankur Bawiskar]

@GemDev 

sorry but without some screenshots can't help.

how is the u_risk_register table record looking like?

what all is stored there?

[GemDev]

Here's how the form looks, is there any specific info I can provide in addition?

[Ankur Bawiskar]

@GemDev 

try this

(function refineQuery(current, parent) {
current.addQuery('u_assigned_to_vendor', parent.u_business_application.vendor);
})(current, parent);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[GemDev]

Thanks Ankur.
I tried that one out and it returns all Risk records.

[Ankur Bawiskar]

@GemDev 

sorry but without screenshots can't help much

If my response helped please mark it correct and close the thread so that it benefits future readers.