/build/static/layout/Breadcrumb_cap_w.png

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.   

w8VzyE7+1uztAAAAABJRU5ErkJggg==

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?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 9 months ago
Red Belt
0

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




Comments:
  • Will this example be able to handle thousands of potential emails? - MC9921 9 months ago
    • I have no idea, but its the only option in KACE that you have......other than setting the custom field type to User - Hobbsy 9 months ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ