Email based Custom Fields - getting the "Select User to add" option in CC List
I'm trying to create a email custom field and what is being requested is a dropdown that provide a list of the available users and their email addresses, like this example.
I haven't seen any option in Field Type to duplicate this, how can this be set up to be like the option in CC list?
Answers (1)
You can create this using an SQL statement within the custom field (but it is complex!!)
In your SMA go to service Desk > Configuration
The select Queues and your queue
Then click "Customize fields and layout" and scroll down to the custom field area.
Click the small blue question mark next to the Custom Field heading to show the help text.
There is an example something like "query: select distinct(LOCATION) from USER"
Which doesnt actually work........but never mind ......move on.
So if you want a list of users or their email address you will need to build an SQL statement to use such as...
query: SELECT USER.USER_NAME FROM USER JOIN USER_LABEL_JT ON USER.ID = USER_LABEL_JT.USER_ID WHERE USER_LABEL_JT.LABEL_ID = 37
To do this you will need to add the users that you want to show into a label and then identify the label ID, that will be the value shown as 37 in the above example.
If you want to show email addresses rather than names change the USER.USER_NAME field to USER.EMAIL
