
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 05:57 AM
Hey there SN Comm Team,
I am in need of some help to hide certain choices from a custom field when the logged in user does not belong to the Human Resources Department.
The field and choices are on the HRIT Operations table
Department field sits on the user table (sys_user)
I also need to hide these choices on the portal side. The variable I am using is a reference type. Using a reference qualifier to reference the choices so that I did not have to duplicate all the choices (there are 37).
I believe I have to use both Script Include with Ajax and a Client Script, but having difficulty scripting it.
Can someone lend me a hand and show me the way 🙂
Thank you in advance,
-Rob
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 07:46 AM
Hello Rob,
If your requirement is to use a drop down field then I would suggest not to use the reference type field. You can use the Select box type (choice type) field which is a best practice, because if you have a requirement to create UI policy on this field or Hide other fields based on this field value if future, then it will be difficult for you or team to implement the UI Policy because the reference qualifier will not be applicable on condition field in UI policy table. So you we end up having 100s of value for your field when creating UI Policy.
If you are using the Select box type field then you can use the below code:
function onLoad() {
var ga = new GlideAjax("DepartmentUtilsCustom");
ga.addParam('sysparm_name', 'isUserFromHrDepartment');
ga.getXMLAnswer(getResources);
function getResources(response) {
var answer = response;
alert(answer);
if (!answer || answer == "false") {
var removeOptions = ["value1", "value2", "value3"]; // you can add the drop-down choice field value that you want to remove
for (var optionValues in removeOptions) {
g_form.removeOption("<YOUR_FIELD_NAME>", removeOptions[optionValues]);
}
}
}
}
Create a System property:
Name: hr.department.sys_id
Value: <sys_id of human resource department in your instance>
Script include:
var DepartmentUtilsCustom = Class.create();
DepartmentUtilsCustom.prototype = Object.extendsObject(AbstractAjaxProcessor, {
isUserFromHrDepartment: function () {
// As the department of logged in user will not change frequently we can get the Department ID of logged user from user's current session
return (gs.getUser().getDepartmentID() == gs.getProperty("hr.department.sys_id"));
},
type: 'DepartmentUtilsCustom'
});
Please mark my respsone as helpful/correct, if it answer your question.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 08:13 AM
Hello Mahendra,
The field on my record producer is a Lookup Select Box. And I have it looking up the sys_choice table. And I have a reference qual to tell it where to look. I did that so I would not have to duplicate all the choices into answers for the record producer variable.
When I change the field to a select box, I lose the option to add the reference qual to tell the field where to get the choices from.
So, I do not see, unless I duplicate all the choices into answers for the Select Box type, where I would still get the choices.
Any suggestions on that?
Thank you,
-Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 08:24 AM
Hello Rob,
Can you please check once if the below options on Select box type field helps you:
In this variable I am trying to show the Impact field's choice values from Incident table on my Impact variable
Please mark my respsone as helpful/correct, if it answer your question.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 08:27 AM
Hello,
Yes I am in the right direction now, that was 100 percent my fault. I missed changing the choice table from what I had already and thought I did change that.
I will continue with the rest and let you know.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 08:42 AM
Hello,
Here is what I have - which is not working for me:
system property:
Client Script:
Script Include:
Variable on my record producer:
Any issues you see here?
Am I scripting the element name and the value of what I want to hide?
Thanks,
-Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2022 09:00 AM
Hello Rob,
Can you please set Client callable to true on your script include and check once.
Thanks