get column labels of fields in a table

[xiaix]

Question: When I query a table (GlideRecord query) on the server side (via Script Include), how can I capture the Column Label of each field on the record?

If further information is needed, or if you would like to see my current script include, let me know.

[Brad Tilton · Accepted solution]

Hi David,

Try gr[fieldName].getLabel()

[xiaix]

You, my friend, are Genius!

[poyntzj]

try this

I have used this on quite a few situations and there is a copy change record routine on here that covers this and how I used it

var gr = new GlideRecord('incident');

if(gr.get('number','INC0010001'))

{

recFields = gr.getFields();

for (i=0;i<recFields.size();i++)

{

var glideElement = recFields.get(i);

gs.log(glideElement.getName());

}

}

[xiaix]