Querying the sys_user table from client script (scope app)

[MKelly83]

Hi all

Trying to query "sys_user" table via client script. I want to retrieve the user's id and segment code based on the inputted employee's name (u_formatted_display_name)

I have written the below client script but am getting the below error message

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    if (isLoading || newValue === '') {

          return;

    }

var empName = g_form.getDisplayBox('u_emp_name').value;

var gr = new GlideRecord('sys_user');

gr.addQuery('u_formatted_display_name', empName);

gr.query(myCallBack);

function myCallBack(gr) {

if(gr.next()) {

g_form.setValue('u_emp_id', gr.user_name);

g_form.setValue('u_emp_bg', gr.u_segment);

}

}

}

I can dot.walk to these fields on the form but the issue is the business wants to rename fields from whats in the sys_user table and it can't be a global change.

[MKelly83]

yes both are reference fields to sys user table

u_emp_id

u_emp_bg

[Shishir Srivast · Accepted solution]

if they are the reference fields then you will not be able to see the user_name and emp_bg as it will always show the field value which is set for display true in sys_user table. I think these fields should be string field.

[MKelly83]

Thanks Shishir

Appreciate all your help

[sachin_namjoshi]

You should not use GlideRecord in client script.

It's better and efficient to use GlideAjax.

How to Write Smart GlideAjax Quickly [Part 1]

Regards,

Sachin