To create related list based on RITM form variable value

Divya28 · ‎04-08-2022

My requirement is to create a related list under stockroom table which displays the RITM related to the specific stockroom, I am trying to establish the connect between the two tables using RITM form variable value from Variable Ownerships(sc_item_option_mtom) table, below is the code is am using Relationship

var gr = new GlideRecord('sc_item_option_mtom');
gr.addQuery('sc_item_option.value',parent.sys_id);
gr.query();
var tskIDArr = [];
while (gr.next()) {
tskIDArr.push(gr.request_item.number);

}
var tskIDStr = tskIDArr.join();
current.addQuery('number', tskIDStr);

Not sure what is the problem.

Could anyone please correct me where I am going wrong

Anil Lande · ‎04-08-2022

Hi,

I hope you have configured it like below:

And use below script:

(function refineQuery(current, parent) {

    var gr = new GlideRecord('sc_item_option_mtom');
    gr.addQuery('sc_item_option.value', parent.sys_id);
    gr.query();
    var tskIDArr = [];
    while (gr.next()) {
        tskIDArr.push(gr.request_item.number);

    }
    var tskIDStr = tskIDArr.join();
    current.addQuery('number','IN', tskIDStr.toString());

})(current, parent);

Thanks,
Anil Lande

View solution in original post

Divya28 · ‎04-08-2022

Thank you, this is working