Reference Qualifier on Catalog multirow variable

[Mahesh Kumar7]

I have a service catalog where I have two fields :

1. Contract Number - Single line text (independent variable)

2. Assets (Multi row variable set having one variable of type reference to asset)

Now, when I enter Contract Number, I should see only those assets which are associated in that contract.

I wrote a script include :

getAssetsForCustomer: function(contractNumber) {
		gs.info('Checkpoint 1 '+contractNumber);
        if (contractNumber == '') {
			gs.info('Checkpoint 2 '+contractNumber);
            return '';
        } else {
			gs.info('Checkpoint 3 '+contractNumber);
			var contractId = '';
            var grContract = new GlideRecord("ast_contract");
            grContract.addQuery("number", contractNumber);
            grContract.query();
            if (grContract.next()) {
				contractId = grContract.sys_id;
            }
			if(contractId == ''){
				gs.info('Checkpoint - Empty contractId');
				return '';
			}
			var AssetIDs = [];
            var gr = new GlideRecord("clm_m2m_contract_asset");
            gr.addEncodedQuery("contract="+contractId);
            gr.query();
            while (gr.next()) {
				if(AssetIDs.indexOf(gr.asset.toString()) == -1){
					AssetIDs.push(gr.asset.toString());
				}
				
            }
			if(AssetIDs.length == 0){
				return '';
			}else{
				gs.info('Checkpoint 4'+AssetIDs.join(','));
				return 'sys_idIN'+AssetIDs.join(',');
			}

        }
    },

I am calling this function in reference qualifier as below :

javascript:new global.TestUtils().getAssetsForCustomer(current.variables.contract_number);

In the logs I am getting the parameter as undefined(Checkpoint 1 and Checkpoint 2) i.e. current.variables.contract_number is undefined

Could you please help me pass a catalog variable into this function?

Thanks in advance.

[Mahesh Kumar7]

Thanks Ankur for the confirmation.

[ashishsamant]

Hi Mahesh,

We had same problem statement, and we found the solution have posted it in the article link below.
See if this helps you, and if does, please mark it helpfu

https://community.servicenow.com/community?id=community_article&sys_id=b92de10cdb146410fa192183ca9619df 

[ashishsamant]

Hi Mahesh,

We had the same problem statement, and we found the solution have posted it in the article link below.
See if this helps you, and if does, please mark it helpful.

ServiceNow Community Article link

[Jon Ulrich]

Found a workaround.

1. Create onChange client script on the item level that writes the independent variable value to a global javascript variable:

function onChange(control, oldValue, newValue, isLoading) {
    contract_number = newValue;
}

2. Create duplicate variable for the independent variable on the MRVS. You can set the variable Hidden so it is not seen on the MVRS. You can also just leave the data type as Single Line Text as all we are concerned with is the value.

3. Create onLoad client script on the MRVS to set the duplicate variable value 

function onLoad() {
   g_form.setValue('contract_number',contract_number);
}

4. Voila, everything should work from here!

[Geoff_T]

Hi @Jon Ulrich, I'm playing about with your suggested workaround here. I cannot get it working.

Issue is that the 'global' variable I am setting on the Catalog Item onChange script seems not to be available to the onLoad script on the MRVS with error:

ReferenceError: variableToPass is not defined

Sample code:

// onChange script on catalog item level - populates 'variableToPass' as expected

var variableToPass = "";

function onChange(control, oldValue, newValue, isLoading) 
{
	if(isLoading || newValue == '') 
	{
		return;
	}
	
	variableToPass = newValue;
	console.log("variableToPass OC " + variableToPass);
}

//onLoad script of MRVS - 'variableToPass' not defined

function onLoad() 
{
	console.log("variableToPass " + variableToPass);
	g_form.setValue('variableToPass', variableToPass);
}

Anything I may have missed? Not sure I want to use this implementation but I'd least like to get it working and decide from there.

Thanks