how to get child table field into parent table

[yekambaram]

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

[Chuck Tomasi]

Go to System Properties> UI Properties and check this field.

Set it to true and you can then drill in to fields on extended tables.

[Abhinay Erra]

I never knew this existed.

[Chuck Tomasi]

It's been there for a while. I think it was a Dublin thing, but don't quote me on that. It's handy on reports and lists.

[yekambaram]

Sorry its not working chuck,

i tried using joinquary but i didn't get the correct response

  var child = new GlideRecord('cmdb_ci');

                    child.addQuery('sys_id', childs);

  var s= child.addJoinQuery('cmdb_ci_server');

  s.addCondition('classification','production');

child.query();

I think here i am missing the relation ship between tables.Is this the right approach,if yes please correct me where i went wrong

[Chuck Tomasi]

Hi Suresh,

We have several different solutions in this thread pointing to several different symptoms. Can you clarify exactly what it is you are trying to do? An example and screen shot would be very helpful.