Display multiple values of an attribute in dynamic attribute

[Bharadwaj]

Hi,

We have a case where we are trying to fetch the customproperty1 value of an Organisation into a Dynamic attribute using "Single select option using SQL". We have multiple values that could be stored in customproperty1, for e.g. value of customproperty1= 'A, B'. 

Query being used in dynamic attribute is as follows:

select customproperty1 as ID from customer where description=${Organization} order by id

In the dynamic attribute selection dropdown, we are seeing the value as "A,B". However, we would like to see them as two separate values so that either of them could be selected.

Is there a way to accommodate this because customproperty1 of Organisation is multi-valued attribute?

Thanks!

[rushikeshvartak]

you need to change separator comma is used by multiple select

[Bharadwaj]

Hi @rushikeshvartak , I did not understand what you are trying to convey. Are you asking me to try "multi select using sql query" option? I have tried it already, but that did not help.

Could you please provide a clear response?

Thanks!

[rushikeshvartak]

Comma is separator used by saviynt for multi value attribute hence you need to use other separator or use replace condition

select replace(customproperty1,’,’,’-‘)as ID from customer where description=${Organization} order by id

[Bharadwaj]

I have tried according to the method you mentioned, but this did not help.

Any other possibility?

Thanks!

[rushikeshvartak]

Share query

cp data

expected data