*How to Query a Base Table to get info from an extended table*

[S_C Pressley]

Query Base table for information regarding its extended table 

Query a Base Table - Get a Record/Fields on an Extended Table

var grChildTable;
var childFieldValues = [];
var baseTable = 'cmdb_ci'; //A base table that's extended
var childTableFieldName = 'name'; //The name of a field on an extended table
var grBaseTable = new GlideRecord('cmdb_ci');

grBaseTable.addQuery('some_query');
grBaseTable.query();

while (grBaseTable.next()) {
    grChildTable = new GlideRecordUtil().getGR(
        grBaseTable.getValue('sys_class_name'), //Table name 
        grBaseTable.getValue('sys_id') //sys_id
    );
    
    childFieldValues.push(
        grChildTable.getValue(childTableFieldName)
    );
}


If this helped you in anyway please mark this helpful or correct. Happy Developing! 

[S_C Pressley · Accepted solution]

var grChildTable;
var childFieldValues = [];
var baseTable = 'cmdb_ci'; //A base table that's extended
var childTableFieldName = 'name'; //The name of a field on an extended table
var grBaseTable = new GlideRecord('cmdb_ci');

grBaseTable.addQuery('some_query');
grBaseTable.query();

while (grBaseTable.next()) {
    grChildTable = new GlideRecordUtil().getGR(
        grBaseTable.getValue('sys_class_name'), //Table name 
        grBaseTable.getValue('sys_id') //sys_id
    );
    
    childFieldValues.push(
        grChildTable.getValue(childTableFieldName)
    );
}


If this helped you in anyway please mark this helpful or correct. Happy Developing!