Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Store two seperate dynamic attributes in a single account customproperty

SSinha_
Regular Contributor
Regular Contributor

Hi team,

I have two dynamic attribute DA1 and DA2 on the request form, for service account. Is it possible to store the concatination of these two attributes in a single account customproperty?

Thanks.

13 REPLIES 13

rushikeshvartak
All-Star
All-Star

No its not supported OOTB, use enahcned query


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Amit_Malik
Valued Contributor II
Valued Contributor II

Have you tried having another DA , something like 

Select concat(${DA1},' ', ${DA2}) as ID

Use account column  

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

SSinha_
Regular Contributor
Regular Contributor

Yes I tried this already but did not work

NM
Honored Contributor II
Honored Contributor II

@SSinha_ no supported .. create a seperate DA and store the combined value in one customproperty.

SSinha_
Regular Contributor
Regular Contributor

I tried concatinating but no query seems to be working , do you have any sample ones?

Amit_Malik
Valued Contributor II
Valued Contributor II

Amit_Malik_0-1726042615678.png

Amit_Malik_2-1726042733424.png

 

One screen shot showing that it is working. Another , with DA's settings.

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

SSinha_
Regular Contributor
Regular Contributor

One of my attributes is ENUM and other is SQL ENUM , is it working for those two?

Amit_Malik
Valued Contributor II
Valued Contributor II

Yes

Amit_Malik_0-1726047323221.png

 

Amit_Malik_1-1726047354827.png

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

SSinha_
Regular Contributor
Regular Contributor

For me it is only populating the value of parent attribute in DA3 i.e DA1 it is not concatinating the value of DA2

Amit_Malik
Valued Contributor II
Valued Contributor II

can you send the screen shot ? I have sent you screen shot of it working , hope you are using the configs as shared in screen shots 

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

Amit_Malik
Valued Contributor II
Valued Contributor II

I also had same issue earlier but after some hit and trial , I could make it work and have shared you the configs that are working

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".

It will not work with ENUM. both needs to be SQL ENUM


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Amit_Malik_0-1726061280473.pngAmit_Malik_1-1726061311240.png

it is working for me. One is ENUM and another SQL ENUM

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".