How to Get Reference field values of a Record with Record SysId ??

[Tarun2]

Hi , 

I have few doubts with Scripting

1.How to  know How many Reference Fields are present in a Record ??   i have Record sysd_id

                    and 

2.How to know the value of Reference Field in a Record ?   Value not  , sys_id of field .

  My  Requirement :

I have a  Table:

Schema Table has Refereence Field linked to DataBase Table .

Schema table Record_1 is Linked to Database Table Record_

With Sys_Id of Schema Table Record  i want to fetch the Related Record (i.e Database Table Record_1 name )

Thankyou ,

[Himanshu Dubey]

You can directly gilde particular table and pass the sys_id of the record

var gr = new GlideRecord('incident');  // table name
gr.get('7f71107c1bb60010445ffcc8cc4bcb3f'); //sys_id of record
gr.query();
if(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 

Results are bot displaying .

[test136]

Its working for me please check your record id is correct or not

[Himanshu Dubey]

It's working for me please check your record id whether it is correct or not