how to get child table field into parent table

yekambaram
Kilo Contributor

Hi thanks in adv,

How to get child table field into parent table.

Eg: parent table is cmdb_ci table and child table is cmdb_ci_server.

the field classification is present in cmdb_ci_server table but i want to get that filed into parent table cmdb_ci table

  var child = new GlideRecord('cmdb_ci');

                     

  child.addQuery('operational_status',1); //operational status field is present in cmdb_ci table so it gets filtred and working fine

but when i try to filter child table field its not getting

child.addQuery('classification','production'); // its not working because the classification field is present in the cmdb_ci_server.

how to filter the records based on classifiacation from cmdb_ci glide record

20 REPLIES 20

Abhinay Erra
Giga Sage

The code I posted should get you there.