How to hide values of subcategory

vivian08081 · ‎08-27-2017

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?

Shishir Srivast · ‎08-27-2017

Hi Wei,

I have tried below and it works, let me try to explain in details if this helps. Created a column (Right Click on the list header then configure -> List Layout) on sys_choice table and then create a new column Choice Not Needed (true/false type) and set the value to true for the records which you don't want to display. Refer the screen shot below.

then create a script include with below code. You might need to fine tune the code based upon your field name.

var GetListValue = Class.create();

GetListValue.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getList : function()

{

var ids = [];

var gr = new GlideRecord('sys_choice');

gr.addQuery('dependent_value', current.u_category.value); //Considering category is also a reference field.

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

gr.addQuery('u_choice_not_needed', 'false');

gr.query();

while(gr.next())

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

return 'sys_idIN' + ids;

},

type: 'GetListValue'

});

and then set the reference qualifier on subcategory field like below.

Result: It's displaying the value of subcategory for which Choice Not Needed is set to false

View solution in original post

Deepak Ingale1 · ‎08-27-2017

If I understand correctly, you are using "subcategory" as reference field and not a choice field.

In that case, you can apply "Reference quailifer" and only show those subcategories which you are interested in.

Reference Qualifiers - ServiceNow Wiki

Karthik Reddy T · ‎08-27-2017

Hello Wei Jiang,

As of my knowledge sub category(Choice field) is the depending upon category in the incident module. So you can write client script to for the required condition to deactivate for the sub category.Let me know what is exact requirement. Can you please give more inputs for this requirement.

Karthik Reddy T.
ServiceNow Commnunity MVP -2018 class.

Harsh Vardhan · ‎08-27-2017

Hi Wei,

can you let us know what type of field is that?

by the way i think there is already restriction has been implement to dynamically populate the subcategory values. might be possible that conflicting

can you please share the screenshot of your form? on what basis you want to to hide or restrict the subcategories ?

vivian08081 · ‎08-27-2017

subcategory is a choice list reference with category.

For example, when Category - software, do not want to Subcategory - Operation System can select from drop down list from subcategory anymore. Do not want to the value inactive.