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
Thank you for you help, one more question
I couldn't find the reference specification section displayed on my instance.But it does have.
How to let it show on incident form??
You need to change the field type from String to Reference.
When I modified the reference specification, then submit it, I got the following error message. Do you know how to fix it?
