Including Email Address in Requested For Variable

TStark · ‎01-13-2022

I have a form (Category Item) with a field named Requested For. This field is a reference to the sys_user table. How do I include the sys_user's email address in the view of the dropdown of this field?

Thanks,
AJ

TStark · ‎01-14-2022

* The Situation:

OOB, users without a role do not have access to other users email address. An example of this is I have category item (form) with the variable Requested For. This variable is a reference to the sys_user table and as a user with a role (i.e. ITIL) I can click the Requested For and see the first/last name and email address of all users in the sys_user table. However, when a user without a role (i.e. an employee) clicks on the Requested For they only see the first/last name.

* The Question:

How do I make it possible for users without a role to see the first/name and email address of all users when they click on the Requested For?

* NOTE:

- Using a variable type Select Box is not an option because this type is limited to 10,000 records.

* The Solution:

- I noticed that there are several ACLs: 1. an ACL: "sys_user*" that prevents a user without a role from viewing any other user record other than their own and 2. an ACL: "sys_user.name" which allows any user to view the First and Last name of any user. I used the "sys_user.name" ACL to create (Insert and Stay) an ACL to allow any user to also view the email of any other user including themselves. After doing this any user in the system is now able to click on the Requested For field and see both the First/Last Name and Email of any user in the sys_user table.

Thanks to Jim and Saurav for their input which provided leads to my solution.

- AJ

View solution in original post

Jim Coyne · ‎01-13-2022

This Docs article will help you out:

https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/field-administration...

The "ref_ac_columns" attribute is what allows extra fields to be added to the list.

TStark · ‎01-13-2022

Hi Jim,

Thanks for you reply. The problem I'm running into is I'm able to accomplish this, listing the name and email address in the dropdown, for users with ITIL role. However, when a non ITIL role user clicks on the Requested For dropdown they only see the first/last name. I need all users, ITIL role or non, to see first/last name and email address.

Thanks,
AJ

Saurav11 · ‎01-13-2022

Hello AJ,

Not sure if you saw my comments but you can achieve it using the lookup type varibale as below:-

Enter the fields you want to display in the field as below:-

Then the field will appear as below:-

Please mark the answer correct/helpful based on impact

TStark · ‎01-13-2022

Hi Saurav,

One problem with using a Lookup Select Box is it is limited to 10,000 records. I have over 10,000 records that need to be accessible. Therefore a Reference type variable is my only option.

Thanks,
AJ