Multiple Select from SQL Query Not Working

[AashishD]

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?

[rushikeshvartak]

Screenshot please .

note : always use proper labels instead of alls

[AashishD]

Hi Rushikesh,

Please find the screenshot attached.

The same query works with Single select with SQL Query

[rushikeshvartak]

Add limit in query

[AashishD]

Hi Rushikesh,

This also does not work.

[jayasudha]

Hi,

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

Thanks,

Jayasudha R

[AashishD]

Hi Jaya,

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

[jayasudha]

Hi,

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

Regards,

Jayasudha R

[AashishD]

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.

[rushikeshvartak]

What about static fields

select 1 as id union 2 as id

try below query

select email as id from users limit 2

[AashishD]

Hi Rushi,

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

[rushikeshvartak]

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