Relationship Query script from string

[DoDo labs___]

Hi!

I have created the following script in Relationship:

(function refineQuery(current, parent) {

var lista = '';

var tomb = [];

var gr = new GlideRecord('problem');

gr.addQuery('number', current.sys_id);

gr.query();

if (gr.next())

    {

        lista = gr.u_change_list;

    }  

tomb = lista.split(",");

for (var i = 0; i < tomb.length; i++)

    {

        current.addQuery(tomb[i], parent.number);

    }

})(current, parent);

In the Problem table, there is a string-type dictionary entries. This entry contains change requests separated by commas. For example: CHG0034611,CHG0034595,CHG0034539.
I would like to display these in the related list, but no changes are displayed.

Can anyone please help me regarding it.

Thanks!

[Sandeep Rajput]

@DoDo labs___ Could you please update the script as follows and see if it works.

(function refineQuery(current, parent) {

var lista = '';
var tomb = [];

var gr = new GlideRecord('problem');
gr.addQuery('number', current.sys_id);
gr.query();
if (gr.next())
    {
        lista = gr.u_change_list;
    }  

tomb = lista.split(",");

for (var i = 0; i < tomb.length; i++)
    {
        current.addQuery('number', tomb[i]);
    }

})(current, parent);

Hope this helps.

[DoDo labs___]

Unfortunately, no changes have displayed yet.

[Community Alums]

Hi @DoDo labs___ ,

I think the issue is with the query-

Can you please try the below script-

(function refineQuery(current, parent) {
    var lista = '';
    var tomb = [];

    var gr = new GlideRecord('problem');
    gr.addQuery('number', current.sys_id);
    gr.query();
    if (gr.next()) {
        lista = gr.u_change_list;
    }

    // Split the list of change requests
    tomb = lista.split(",");

    // Build the query for the related list
    var changeGr = new GlideRecord('change_request');
    var encodedQuery = '';
    for (var i = 0; i < tomb.length; i++) {
        if (i > 0) {
            encodedQuery += '^OR';
        }
        encodedQuery += 'number=' + tomb[i];
    }
    if (encodedQuery) {
        current.addEncodedQuery(encodedQuery);
    }

})(current, parent);

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks & Regards,

Sanjay Kumar

[Sandeep Rajput]

@Community Alums Good catch.

@DoDo labs___ The script I suggested, is now updated based on Sanjay's suggestion.

(function refineQuery(current, parent) {

var lista = '';
var gr = new GlideRecord('problem');
gr.addQuery('number', current.sys_id);
gr.query();
if (gr.next())
    {
        lista = gr.u_change_list;
    }        
 current.addEncodedQuery('numberIN'+lista);

})(current, parent);