We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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.