How do I get List values using Script Include

SD4
Tera Contributor

I have a table that contains a List field with multiple values

find_real_file.png

How do I get those values from that field using script include

 find_real_file.png

 

1 ACCEPTED SOLUTION

Anil Lande
Kilo Patron

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

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

15 REPLIES 15

IncludeList.push(member.u_member.sys_id.toString()) 

 

Adjust the return string

"active=true^sys_idIN" + IncludeList.toString();

 

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

SD4
Tera Contributor

No same showing

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

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

-O-
Kilo Patron
Kilo Patron

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.

SD4
Tera Contributor

Hi Anil,

Now I am getting all the members as a dropdown...

but How can I achieve this-

find_real_file.png