Script Include returning null

[Raviteja K]

Hello Everyone

I have following client script

var userDet = g_form.getReference('openedfor');

var ga = new GlideAjax('HRManagerApprovalCheck');

ga.addParam('sysparm_name','ApprovalCheck');

ga.addParam('sysparam_userDet','userDet');

ga.getXML(GetCountryDetails);

function GetCountryDetails(response) {

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

    alert(answer);

}

and following script include

getUserData: function()

{

var userDet = this.getParameter('sysparam_userDet');

var det = userDet.country;

var countryapp='';

var user = new GlideRecord('u_hr_country_and_approval_lookup');

user.addQuery('u_country',det);

user.query();

while (user.next()) {

countryapp=user.u_line_manager_approval_required;

}

return countryapp;

},

This should Yes, but returning null

Need to do any changes to the client script or script include.

Thanks in advance.

[samiul1]

Try the below: (untested though, but will give you idea)

=============================================

//start of Client Script:

~~~~~~~~~~~~~~~~~~~~~~~~~~~

function onload/onChange() {

        var userDet = g_form.getReference('openedfor', callBackFunction); //below

        //Glide Ajax

        var ga = new GlideAjax('HRManagerApprovalCheck');         //Script Include

        ga.addParam('sysparm_name','ApprovalCheck');                         //function name within Script Include

        ga.addParam('sysparam_userDet', userDet);                                       //pass the parameter

        ga.getXML(GetCountryDetails);

}

function callBackFunction(userDet) {

        if (userDet.country != '')

                  return userDet.country;

}

function GetCountryDetails(response) {

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

                        alert(answer);

}

//end of the Client Script

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Script Include

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ApprovalCheck: function() {

        var userDet = this.getParameter('sysparam_userDet');

        var countryapp='';

        var user = new GlideRecord('u_hr_country_and_approval_lookup');

        user.addQuery('u_country', userDet );

        user.query();

        if (user.next()) {

                  countryapp=user.u_line_manager_approval_required;

        }

        return countryapp;

},

[samiul1]

Hi Ravi,

Could you provide an update on your issue?

Has it resolved?

Any of the thread was Helpful?

Thanks,

Samiul

[Raju Koyagura]

Please change the highlighted line number userDet should be a variable not a string to pass to ga.addParam

var userDet = g_form.getReference('openedfor');

var ga = new GlideAjax('HRManagerApprovalCheck');

ga.addParam('sysparm_name','ApprovalCheck');

ga.addParam('sysparam_userDet',userDet); //ga.addParam('sysparam_userDet','userDet');

ga.getXML(GetCountryDetails);

[Raviteja K]

not working, still returning null value

[Shishir Srivast]

I think, below highlighted line is wrong.

getUserData: function(){

var userDet = this.getParameter('sysparam_userDet');

var det = userDet.country; //I don't think this will work to get the country, you need to glide the record first on table to get the country details first then based upon that try to get the required details.

var countryapp='';

var user = new GlideRecord('u_hr_country_and_approval_lookup');

user.addQuery('u_country',det);

user.query();

while (user.next()) {

countryapp=user.u_line_manager_approval_required.toString(); //Adding toString() here

}

return countryapp;

}