sysparm_fields to get all the fields along with display value of reference field

[kailashthiyagar]

How to get all the fields in the table along with display value for few of the columns

is it possible to get something like "sysparm_fields=*, team_leader.employee_number"?

[Jon Barnes]

I believe getting display value is all or nothing, and you can't do it for only some fields using the OOB table APIs.

also, there may be performance concerns with pulling display values for every field in the table. I would recommend choosing precisely which fields you want and pull those only.

getting display values for reference fields have an extra glide record query, which is where some of the performance concerns come from.

and yes, you can dot-walk on the sysparm_fields parameter.

[kailashthiyagar]

jbarnesciti

My requirement, i would like to all the fields in my table, and display value for only one field..

i thought we can use something similar to it "sysparm_fields=*, team_leader.employee_number"?

I can mention all the fields in the sysparm_fields but the query will become too long since i have lot of fields.

Any recommendations?

[kailashthiyagar]

sanjivmeher any thoughts?

[SanjivMeher]

You can try using a for loop to build the comma separated field names.

For example if the table name is abc, you can use

var dict = new GlideRecord('sys_dictionary');

dict.addQuery('name','abc');

dict.query();

var fieldnames='';

while(dict.next())

{

        if (fieldnames =='')

                  fieldnames = dict.element;

        else

                  fieldnames = ','+dict.element;

}

var myquery= 'sysparm_fields='+fieldnames;

Not sure, if this is what you were looking for.