How do I get the user email from a list collector to appear on the RITM?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2023 12:52 PM
I have a catalog item that has a list collector populating the user list. From the service portal the requestor is able to see the users and the emails because I added the variable attributes: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true,ref_ac_order_by=name
Is there a way I can have the emails appear on the RITM as well?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2023 12:23 PM
Yeah thats how you can try to get email addresses from your variable.
Just replace with correct variable name and the you may need to iterate over sys_ids of user and get their emails before setting in new users_email variable.
Regards,Sushant Malsure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2023 01:49 PM
In the same variable its not possible as display value for sys_user table is by default set to Name and I am sure you dont want to change that behaviour to email because this change will be instance wide.
Instead you can think of having another read only variable where email address of selected users can be added or removed as per the action performed.
Regards,Sushant Malsure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2023 06:13 AM
I was wanting both to appear on the RITM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-24-2023 10:07 AM
Hi,
You can create new column on sys_user table with calculated value of name & email then use the same column value in RITM.
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution