Reference field UI Policy

kailashthiyagar · ‎11-02-2016

I have a UI policy for one of the reference field. If the value of the reference field is "Other", then show/hide another field. In the UI policy, by default it takes the SysID for the value "Other" rather than the value itself. So everytime, I reload the data , the SysID for the value "Other" is getting changed and the UI policy fails.

Can we force the reference field to take value rather than the sysID.. ?

There is no related fields appear for the particular column...

Abhinay Erra · ‎11-02-2016

Use GlideAjax. Here is the onload and onchange scripts and script include. In my case, if the watch list contains system administrator, show description field or else hide it. Make changes according to your fields and table.

onLoad:

function onLoad() {

   var ga = new GlideAjax('DisplayUtil');

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

   ga.addParam('sysparm_id',g_form.getValue('watch_list'));

   ga.getXML(CallBack);


   function CallBack(response) {

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

   if(answer=='true'){

   g_form.setDisplay('description',true);

   }

   else{

   g_form.setDisplay('description',false);

   }

   }

}

onChange:

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

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

   return;

   }

   var ga = new GlideAjax('DisplayUtil');

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

   ga.addParam('sysparm_id',newValue);

   ga.getXML(CallBack);


   function CallBack(response) {

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

   if(answer=='true'){

   g_form.setDisplay('description',true);

   }

   else{

   g_form.setDisplay('description',false);

   }

   }

   //Type appropriate comment here, and begin script below


}

Script Include:

Name:DisplayUtil

client callable:true

script:

var DisplayUtil = Class.create();

DisplayUtil.prototype = Object.extendsObject(AbstractAjaxProcessor, {

   checkList: function(){

   var gr= new GlideRecord('sys_user');

   gr.addQuery('sys_id','IN',this.getParameter('sysparm_id'));

   gr.query();

   while(gr.next()){

   if(gr.name=='System Administrator')

   return true;

   }

   return false;

   },

   type: 'DisplayUtil'

});

View solution in original post

kailashthiyagar · ‎11-02-2016

For using Scripted UI policy, i should have a condition rit.. Since i dont have the condition, i m not able to use Advance scripting...

Here my condition itself whether the particular reference field is other or not..

Kalaiarasan Pus · ‎11-02-2016

Why not dot walk the field and use name or whatever is equivalent for your table field instead of sys id? That should work fine with your current setup without much change.

kailashthiyagar · ‎11-02-2016

Yes Kalai.. That sounds like feasible option but i m not finding related fields for that particular field.. Dont know why

Kalaiarasan Pus · ‎11-02-2016

Can you share a screenshot of your UI policy?

kailashthiyagar · ‎11-02-2016

Here file name is my reference field which doesnt show any related fields