- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 08:42 AM
I have a table that contains a List field with multiple values
How do I get those values from that field using script include
Solved! Go to Solution.
- Labels:
-
Service Portal Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 08:48 AM
Hi,
Instead of getDisplayValue() use IncludeList.push(member.u_member.toString());
Also it would be helpful if you can share some background and information about which table store what.
Thanks,
Anil Lnade
Thanks
Anil Lande
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 09:26 AM
IncludeList.push(member.u_member.sys_id.toString())
Adjust the return string
"active=true^sys_idIN" + IncludeList.toString();
Vinod Kumar Kachineni
Community Rising Star 2022
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 09:33 AM
No same showing

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 09:28 AM
Please try appending .toString() after all variables.
like:
member.addQuery('u_email_address',DlEmail.toString());
and
gs.log(IncludeList.toString());
also update the return line like below.
return 'active=true^sys_idIN'+IncludeList.toString();
Thanks,
Anil Lande
Thanks
Anil Lande
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 09:35 AM
So, if your requirement is that when Email Address changes, to look up the user having that e-mail address and to add that user to the Member List collector, reference qualifier is the wrong way to do it. In fact it is not the way to do it at all. You need to create an onChange Catalog Client Script for field Email Address, call the Script Include using GlideAjax and add the returned user id to the List collector. Of course you would need to either re-write for that purpose the Member method of the Script Include, or create a new one that return the user associated with the e-mail address entered.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 09:43 AM