question Re: Querying the sys_user table from client script (scope app) in Developer forum

Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 12:00:31 GMT

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.

Re: Querying the sys_user table from client script (scope app)

Gaurav Bajaj — Fri, 19 Jan 2018 12:06:17 GMT

HI Michelle,

Please use get reference callback instead of using Gliderecord in client script.

https://www.servicenowguru.com/scripting/client-scripts-scripting/gform-getreference-callback/

Thanks

Gaurav

Re: Querying the sys_user table from client script (scope app)

Lakshmaiah Dump — Fri, 19 Jan 2018 12:07:31 GMT

Hi,

In client scripts you can't use the GlideRecord Object in client side scripts,

In client side available only g_form and g_user objects to get the form data and current loggedin user info.

Change following code as ur requirement

function onChange(control, oldValue, newValue, isLoading) { var caller = g_form.getReference('caller_id', doAlert); // doAlert is our callback function } function doAlert(caller) { //reference is passed into callback as first arguments if (caller.vip == 'true') alert('Caller is a VIP!'); }

Hit âœ…Correct, â�ï¸�Helpful, or â�£ï¸�Like, Endorsers depending on the impact of the response

@Lakshmaiah Dumpala

Re: Querying the sys_user table from client script (scope app)

sachin_namjoshi — Fri, 19 Jan 2018 14:00:32 GMT

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

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 14:39:04 GMT

Thanks Gaurav

I have tried to use the get reference callback alert is returning "undefined"

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

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

return;

}

var employee = g_form.getReference('u_emp_name', setemployeedetails );

function setemployeedetails(empName) {

alert(employee);

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

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

}

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 16:07:32 GMT

Thanks Lakshmaiah

I have tried to use the get reference callback alert is returning "undefined"

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

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

return;

}

var employee = g_form.getReference('u_emp_name', setemployeedetails );

function setemployeedetails(empName) {

alert(employee);

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

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

}

Re: Querying the sys_user table from client script (scope app)

Shishir Srivast — Fri, 19 Jan 2018 16:11:49 GMT

I think it should be like,

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

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

return;

}

var employee = g_form.getReference('u_emp_name', setemployeedetails );

function setemployeedetails(employee) {

alert(employee);

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

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

}

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 16:20:43 GMT

thanks Shishir

this is returning

Re: Querying the sys_user table from client script (scope app)

Shishir Srivast — Fri, 19 Jan 2018 16:24:00 GMT

I think, that's fine, what you get with there alerts?

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

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

return;

}

var employee = g_form.getReference('u_emp_name', setemployeedetails );

function setemployeedetails(employee) {

alert(employee.user_name);

alert(employee.u_segment);

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

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

}

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 16:29:58 GMT

yes shishir, it is alerting the correct value now but not setting the values in fields

Re: Querying the sys_user table from client script (scope app)

Shishir Srivast — Fri, 19 Jan 2018 16:33:08 GMT

is u_emp_id and u_emp_bg are reference field? Can you please provide some screenshot?

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 16:46:12 GMT

yes both are reference fields to sys user table

u_emp_id

u_emp_bg

Re: Querying the sys_user table from client script (scope app)

Shishir Srivast — Fri, 19 Jan 2018 16:51:02 GMT

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.

Re: Querying the sys_user table from client script (scope app)

MKelly83 — Fri, 19 Jan 2018 16:57:12 GMT

Thanks Shishir

Appreciate all your help