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 Ashutosh. Any suggestions on accessing another Table from Script Include?

[Ashutosh Munot1]

in script include use glideRecord it will work

[Deepa Srivastav · Accepted solution]

Hi Neha ,

Try something as below in script include:-

var sysid = this.getParameter('sysparm_sys_id')   ;
var gr1 = new GlideRecord('sys_user');

                              gr1.addQuery('sys_id', sysid )

                              gr1.query();
                         

                                while(gr1.next())

                                    gs.log('user exists');

                                      return true;
                              }

Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.

Thanks,
Deepa

[nehapateria]

Hi Deepa,

I wrote below Client Script and Script Include but getting 'null' value as an alert. Please suggest.

Client Script:-

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

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

          return;

    }

                              var sysid = g_form.getValue('sys_id');

                              var ga1 = new GlideAjax('ValidateUser');

                              ga1.addParam('sysparm_name', 'checkUser');

                        ga1.addParam('sysparm_newValue', newValue);

                        ga1.addParam('sysparm_sys_id', sysid);

                              ga1.getXML(UserParse);

                              function UserParse(response)

                              {

                                var answer = response.responseXML.documentElement.getAttribute("answer");

                                alert(answer);

                              }

    //Type appropriate comment here, and begin script below

}

Script Include:-

var ValidateUser = Class.create();

ValidateUser.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

    checkUser: function() {

  var userid = this .getParameter('sysparm_newValue');  

  var sysid = this.getParameter('sysparm_sys_id');

      var gr1 = new GlideRecord('sys_user');

  gr1.addQuery('sys_id', sysid);

  gr1.query();

  while(next())

    return alert('UserID already existing');

          //return "Hello " + this.getParameter('sysparm_user_name') + "!";

    },

    _privateFunction: function() { // this function is not client callable        

    }

});

[Ashutosh Munot1]

return alert('UserID already existing');

please revisit this step.

i guess it is not returning value

try

var a = alert('UserID already existing');

return a;