Querying Another table from Client Script

[nehapateria]

Hi Members,

I have a simple query. I am trying to query 'sys_user' table from my Custom form. I am querying 'user_id'   of my current form to 'user_name' of 'sys_user' table. If the record is found then a user must get an alert that the same UserId exists in the system. For that I have written the below Client Script. Issue is :- I am getting a below error message in the 'user_id' field.

Error:-

onChange script error: TypeError: GlideRecord is not a constructor function (){var o=i(m,arguments);return l.apply(n,o)}

Please Suggest.

Thanks,

Neha

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

                              if(isLoading)

                              {

                                                              return;

                              }

                              var gr1 = new GlideRecord('sys_user');

                              gr1.addQuery('user_name', newValue);

                              gr1.query();

                              myFunc();

                              function myFunc()

                              {

                                while(gr1.next())

                                    alert('USER ID already exists');

                              }

    //Type appropriate comment here, and begin script below

}

[nehapateria]

Thanks Deepa. Any suggestions on accessing another Table from Script Include?

[Ashutosh Munot1]

write script include which queries your table and then call it in Glide Ajax.

it will work

[Robert Beeman]

Hi Neha,

An Ajax called script include calls server side scripting, so it has full access to any server side information. It can access any table that you have access to and can return those results to the client.

[nehapateria]

Thanks Robert. Any suggestions on accessing another Table from Script Include?

[Kalaiarasan Pus]

How to use gliderecord with callback function is shown here

Client Side GlideRecord - ServiceNow Wiki

So in your code, the change would be

gr1.query(myFunc);

Also, the suggestion to use GlideAjax is a best practice while using client scripts.