Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Multiple Select from SQL Query Not Working

AshishDas
Regular Contributor II
Regular Contributor II

Hi,

I am trying to populate a field of users where multiple email users could be selected from the system in the dynamic attribute of a create users form.

I am using Attribute Type as : Multiple select from SQL Query

Values : select email as ID from users

However, this does not work for multiple select (does not populate any values in dropdown) but works only on for single select.

Example given in Freshdesk is :

Example: select 'adam@xyz.com' as ID UNION select 'john@xyz.com' as ID

Any workaround?

11 REPLIES 11

rushikeshvartak
All-Star
All-Star

Screenshot please .

note : always use proper labels instead of alls


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

AshishDas
Regular Contributor II
Regular Contributor II

Hi Rushikesh,

Please find the screenshot attached.

AshishDas_0-1670221061473.png

AshishDas_1-1670221163619.png

The same query works with Single select with SQL Query

Add limit in query


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

AshishDas
Regular Contributor II
Regular Contributor II

Hi Rushikesh,

This also does not work.

AshishDas_0-1670223638234.png

AshishDas_2-1670223572304.png

Hi,

It is working fine. Please see the screenshot below. Can you please share the screenshot of the full dynamic attribute.

jayasudha_0-1670243798626.png

jayasudha_0-1670244072476.png

Thanks,

Jayasudha R

AshishDas
Regular Contributor II
Regular Contributor II

Hi Jaya,

Could you let me know the version in which you have tested the same. Does not work on my version. 2021.0

AshishDas_0-1670263603489.pngAshishDas_1-1670263623344.png

Hi,

I have also tested this on 2021.0. Are you trying to map this value to any user variable?

jayasudha_1-1670310080766.png

Regards,

Jayasudha R

AshishDas
Regular Contributor II
Regular Contributor II

No, we aren't mapping this to any other variable. But this attribute is part of an action string and has a parent attribute as well.

What about static fields

select 1 as id union 2 as id

try below query

select email as id from users limit 2


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

AshishDas
Regular Contributor II
Regular Contributor II

Hi Rushi,

This is also not working. Not sure if if's a bug.

AshishDas_2-1670263751123.pngAshishDas_3-1670263767450.png

It's bug in your version. Can you check logs what query is printing


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.