Reference Qualifier to return sys_id based on String field.

[Sohail Khilji]

Hello NowCommunity,

@Ankur Bawiskar @Allen Andreas @Maik Skoddow @Sandeep Dutta @Mohith Devatte @Jaspal Singh 

On the above form,

Field1 (Reference to cmdb_ci_pc_hardware table) : User  can select their device here.

Field2 (String field) : value is populated once the above field is updated. (GlideAjax - value derived from cmdb_ci_pc_hardware record )

Field3 (Reference) : Here I want to return catalog items whose name starts with 'ex'.

To do so,

i have to do it via on-change client script & script include only (due to my particular requirement). i have a success but the reference field is not getting updated.

SCRIPT INCLUDE :

var getSoftwareByCategory = Class.create();
getSoftwareByCategory.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    populateenv:function() {

        var env = this.getParameter('sysparm_env_ns');
        var RerurnItem = [];

   if (env == 'Normal Secure') {

            var gr1 = new GlideRecord('pc_product_cat_item');
			gr1.addEncodedQuery('nameSTARTSWITHxe');
            gr1.query();

            while (gr1.next()) {
                RerurnItem.push(gr1.getUniqueValue());
            }
			
  }
		
		return 'sys_idIN' + RerurnItem;
    },


    type: 'getSoftwareByCategory'
});

CLEINT SCRIPT :

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

var env = g_form.getValue('environment');     // field 2 value
	
var ga = new GlideAjax('getSoftwareByCategory');
ga.addParam('sysparm_name','populateenv');
ga.addParam('sysparm_env_ns', env);          // also tried new value
ga.getXML(getCat);
	
function getCat(response){
	
var answer = response.responseXML.documentElement.getAttribute("answer");
	
alert('returned value  : '+answer);
	
}
   
}

REFRENCE FIELD UPDATED:

Result :

Iam able to get the sys_id on the client side, but the reference field is not getting updated....

[alexaria]

Thank Stewe.

this article worked for me:
How to modify Reference Qualifiers with Catalog Client Scripts – ServiceNow – ServiceNow Think (word...

and this is the onChange client script:

var resetFilter = 'active=true^nameISNOTEMPTY^emailISNOTEMPTY^EQ';

var dynamicFilter = g_form.getValue('your other text var holding encoded query').toString().trim();

var gg = g_list.get('your ref var name'); // GlideList2 object

gg.setQuery(newValue == '' ? resetFilter : dynamicFilter);