Print full row of table

[Sneha39]

Hi,

Is it possible to print full row of table in ServiceNow ?

For example :

Instead of getting First Name , Last Name etc like below :

var gr = new GlideRecord('sys_user');  

gr.get('email','user@gmail.com');  

gs.print('FirstName'+gr.first_name);

Is it possible to get complete detail of user( full row) from table

Thanks

[sachin_namjoshi]

Please use below

getFieldValues('INCD045011'); // please updated record as per your requirement

function getFieldValues(incNumber) {

      var target = new GlideRecord('incident');

      target.addQuery('number', incNumber);

      target.query();

      var gru = new GlideRecordUtil();

      while (target.next()) {

              var fieldNames = gru.getFields(target);

              for (var i = 0; i <= fieldNames.length; i++) {

                      gs.print("The field: " + fieldNames[i] + " on the current record has a value of: " + target.getValue(fieldNames[i]));

              }

      }

}

Regards,

Sachin

[Jesus Ceniceros]

Hi Sachin,

Is there a way to print field lables instead of field name? because I need to print labels of every field

[chirag_bagdai]

var gr = new GlideRecord('sys_user'); 
gr.get('email','user@gmail.com'); 


var fields = gr.getFields();
for (var i = 0; i < fields.size(); i++) { 
   var field = fields.get(i);
   var name = field.getName(); 
   var value = field.getDisplayValue(); 
   gs.print(i + ". " + name + "=" + value); 
}

[Ishan4]

Hi,

I tried on Quebec version, your script ran well after making some tweaks:

Note: I was running for different table.

var gr = new GlideRecord('cmdb_ci_service_discovered');

gr.query();
gr.next();

gs.print(gr.getTableName());
gs.print(gr.getRowCount());

var gu = new GlideRecordUtil();

var fields = gu.getFields(gr);

gs.print(fields);

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

   var field = fields.get(i);

   var name = field.getName(); 

   var value = field.getDisplayValue(); 

   gs.print(i + ". " + name + "=" + value); 

}

Thanks for clean code..