script to get specific user and set them into a user reference field

[jacobpeterson]

Hello all,

I'm trying to create a UI Policy script that when certain categories are picked it will run the script to get a specific user and sets them into a field.

Here is the script I have so far:

function onCondition() {
 var getUser = new GlideRecord('sys_user');
 getUser.addQuery('user_name', Jdoe);
 getUser.query();
 while (getUser.next()) {
   g_form.setValue('approvalRequestedApproval', getUser);
 }
}

[Chuck Tomasi]

Hi Jacob,

I don't see where Jdoe is defined. You need to figure out which user name you are retrieving. This may be a better use case for a client script and a GlideAjax call.

Docs: Client Scripts

Docs: GlideForm

Docs: GlideAjax

Client Script Best Practices - ServiceNow Wiki

[Ankur Bawiskar]

Hi Jacob,

Don't use UI Policy if you are having something to do with script. Go with client script. Based on your requirement you can either have onLoad client script or onChange client script.

Do you want to set the value on load of the form or when specific category is selected.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Pradeep Sharma]

Hello Jacob,

I'm not sure which field exactly you want to set from the sys_user table. It looks like you have hard coded the user "JDOE" (currently value hard coding is missing in your script i.e   getUser.addQuery('user_name', Jdoe); should be getUser.addQuery('user_name', 'Jdoe');

Can you please give more info on value you want to return from the sys_user table.

[Nate23]

1) UI Policy scripts run client side. GlideRecord is not recommended to use client side. I would use GlideAjax depending on what your condition is to get the user.

2) How do you know what user to assign it to(is it static/dynamic)? Depending on how you answer this tells use what method to use ie: GlideAjax vs. onDisplay Business Rule.

3) The reason it is not working is line 4: Jdoe should be wrapped in quotes like this:

getUser.addQuery('user_name', 'Jdoe');