Including Email Address in Requested For Variable

[TStark]

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

[Saurav11]

So does the mail field have a acl attached to it?

[Saurav11]

Hello,

Please do the below steps:-

Create a variable of type lookup

Then in Type specification, select the table as sys_user and field as email as below:-

Then save it.

Now if you go to the catalog item you will see the field as a dropdown of emails

Please mark the answer correct/helpful based on impact

[TStark · Accepted solution]

* 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

[Saurav11]

Hello,

If you answer helped you can you also mark it correct/helpful based on impact.

Thanks.