How to hide values of subcategory

[vivian08081]

So far we have plenty incident tickets already existing in our instance. We don't want to deactivate any value from subcategory.

Just want to users could not see them from the drop down list.

I try to use client script - onChange - g_form.removeOption('subcategory','email') to implement this. But it doesn't work for the reference fields like subcategory..

Does anyone have any idea to implement this?

[vivian08081]

for your solution, do you mean change the field subcategory's type from string to reference like below?

[Shishir Srivast]

You can not change the existing type from string to reference since reference type field will always have 32 characters. As per the post "it doesn't work for the reference fields like subcategory"   looks like you are using the subcategory as reference field,then why are converting the existing field type. I believe you should be using subcategory as reference field.

Is your Subcategory field is type string? If yes,then we need to have different approach (onChange() + GlideAjax (script include)) with same concept to avoid getting the choice which we do not want.

[vivian08081]

unfortunately, so far the Subcategory field Type is String, not reference.

So could you give another solution for this?

[vivian08081]

By the way, the subcategory is dependent on field Category

[Shishir Srivast]

Please try in this way then, see if this helps.

Client Script:

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

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

return;      

}    

g_form.clearOptions('subcategory');

var ga = new GlideAjax('GetListValue');  

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

ga.addParam('sysparm_cat', newValue);  

ga.getXML(fillDetails);  

function fillDetails(serverResponse)  

{  

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

alert(answer);

var choiceval = answer.split(',');

for(var i = 0; choiceval.length > i ; i++){

g_form.addOption('subcategory', choiceval[i], choiceval[i], [i]);

}

}  

}  

Client Callable Script Include:

var GetListValue = Class.create();

GetListValue.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getList : function()

{

var ids = [];

var gr = new GlideRecord('sys_choice');

gr.addQuery('dependent_value', this.getParameter('sysparm_cat'));

gr.addQuery('name', 'incident');

gr.addQuery('u_choice_not_needed', false);

gr.query();

while(gr.next())

ids.push(gr.label.toString());

return '' + ids;

},

type: 'GetListValue'

});