how to query cmdb_rel_ci table to get parent and child value using glide record

[Abhinab Achary1]

Hi All,

I want to query the child value based on parent value in table cmdb_rel_ci

How can this be done

Thanks,

Abhi

[Chuck Tomasi]

Hi Abhi,

It would look something like this:

var parentId = 'some sys_id of a CI';

var childList = [];

var rel = new GlideRecord('cmdb_rel_ci');

rel.addQuery('parent', parentId);

rel.query();

while (rel.next()) {

        childList.push(rel.getValue('child'));

}

// Now you have an array of sys_ids of the child records

[Abhinab Achary1]

can i write this under script include

[Chuck Tomasi]

Yes, the above snippet is server side code.

Script includes

[Abhinab Achary1]

but the childLIST is an array , now how can this be passed to the client side