How to show the child/sub-account and parent account related KB articles when we select child accoun

[sugand]

Hi,

Have a requirement that whenever a sub-account or child account is selected on the incident form, we should show all the related KB articles corresponding to that child account and parent account. 

Have attached the screenshots for your understanding. Kindly help me with the script for the same.

Thanks,

Sugan

[Peter Bodelier]

Hi @sugand 

If you navigate to ‘System Definition -> Relationships’ and create a new relationship record, use the following script:

(function refineQuery(current, parent) {

current.addQuery('<<your company field name on kb_knowledge>>', parent.sys_id).addOrCondition('<<your company field name on kb_knowledge>>', parent.parent);

})(current, parent);

Applies to table Account or Company

Queries from table Knowledge Article

[sugand]

Hi, 

The actual requirement is all the related knowledge articles of customer account and site (custom table) should show when the sub-account is selected. (all the kb articles of sub-account, parent account should also be shown).

Can you pls correct the script by adding recursive function.

Thanks,

[Peter Bodelier]

Not really sure what is set up here, but I guess, you could accomplish it by extending line 8:

acc.addQuery('u_customer_account',current.u_site.u_account.sys_id).addOrCondition('u_customer_account', u_customer_account',current.u_site.u_account.parent);