How to Get Reference Field Values of a Table ??

[Tarun2]

Hi , 

How to know the value of Reference Field values  in a Record ?   (Value)

var arr_fields=[];

var fields = new GlideRecord('sys_dictionary');

fields.addQuery('name','incident'); // table name

fields.addEncodedQuery('internal_type=reference');//getting reference type fields

fields.query();

while(fields.next())
{
arr_fields.push(fields.column_label.toString()+"("+fields.element.toString() + ")" );
}


for(var i=0; i<arr_fields.length; i++)
{
gs.print(arr_fields[i]);
}

I have multiple reference Fields in Record .

I am getting Reference Field Names (One By One )

  But  I want Reference Field Values .

Any Suggestion is Appreciated .

Thankyou , 

[Harsh Vardhan · Accepted solution]

working script: 

here i tested the script, for my incident table, same way you can do it for your table. 

var gr = new GlideRecord('incident');  // change the table name
gr.addQuery('sys_id','98e902e02f6b4c10f68d5ff62799b609');  // add record id
gr.query();
gr.next();

var fields = gr.getFields();
for(var i = 0;i<fields.size();i++){

var glideElement = fields.get(i);
if (glideElement.hasValue()) {

if(glideElement.getED().getInternalType() == 'reference'){

gs.print(glideElement.getDisplayValue());
}

}

}

[Tarun2]

Hi , 

no errors  BUT 

Result is not displaying . 

[Harsh Vardhan]

connect me on hangout, i am available