Fetch state value from change request table to catalog item

[Shalika]

I have a catalog item with 2 fields 'change request ID' and 'state of change request' . I have to fetch the state of change request based on change request ID. I have written onChange client script for this but it is not working properly.

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading) {
return;
}

var usr = g_form.getReference('change_request_id', callBack);

}

function callBack(usr)
{

g_form.setValue('state_of_change_request', usr.state);

}

It is fetching the value as follow -

In the choice table for state field the value is set as 

It is fetching the value, but I want the label value to be populated on the form. How can I do this?

[IAmAbhigyaan12]

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

  if (isLoading) {

    return;

  }

  var changeRequest = g_form.getValue('change_request_id');

  if (changeRequest) {

    g_form.getReference('change_request_id', callBack, 'change_request');

  }

}

function callBack(reference) {

  if (reference) {

    g_form.setValue('state_of_change_request', reference.getValue('state'));

  }

}

You can check hope this helps.

You can give thumps up, if there is any issue can tag me.

Thanks

Abi

[Shalika]

It is still fetching the value as 1,2 not fetching the label 

[IAmAbhigyaan12]

Create a new script include

var GetStateOfChangeRequest = Class.create();

GetStateOfChangeRequest.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getState: function() {

        var gr = new GlideRecord('change_request');

        gr.addQuery('number', this.getParameter('sysparm_change_request_id'));

        gr.query();

        if (gr.next()) {

            return gr.state.getDisplayValue();

        }

        return '';

    },

    type: 'GetStateOfChangeRequest'

});

And on onChange function you can write this

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

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

        return;

    }

    var ga = new GlideAjax('GetStateOfChangeRequest');

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

    ga.addParam('sysparm_change_request_id', newValue);

    ga.getXMLAnswer(function(answer) {

        g_form.setValue('state_of_change_request', answer);

    });

}

Hope this works

[Shalika]

It is still not fetching the state values