Dynamic Attribute - Populate attribute value from another

[Je]

I hope anyone can help me with this. I've search through most related posts but I don't see anything that has the same use case.

I'm working on a form for one of our endpoints that needs to meet this requirement. First attribute (Att1) allows users to input any text they prefer. Now, I want the second attribute (Att2) to get the value of Att1 and add the phrase "Vault_" in front of it. Example: If the user inputs "Devops" on the Att1, the value of Att2 should auto-populate into "Vault_Devops".

I tried using sql enum on the Att2 and placed " concat('Vault_', ${Att2}) " as the value but it doesn't work. I guess this only works if the data to be displayed is already existing in Saviynt Database. 

Any suggestions for a workaround? Thanks in advance.

[NM]

@Je when I last tried it was not working

String to ENUM Mapping relation isn't supported.

You might have to create a seperate attribute which takes the value from DA1 and then becomes an input for DA3

[rushikeshvartak]

Refer below sample

https://forums.saviynt.com/t5/third-party-access-governance/register-user-form/m-p/83163#M605

[Je]

Hello rushikeshvartak,

Thanks for linking this post. I think I managed to pull it off but there seems to be something wrong with my query. Will you be able to help me out?

I followed the instructions provided by user PremMahadikar. And I'm getting the expected results however, the autopopulating data does not provide the expected results. Whenever I try to simulate the request, the Att2 only gets populated with "Vault_" and does not include the value from Att1.

Can you help check what's wrong with my query? 
select concat ('Vault_',${VaultName}) as ID.

The VaultName is the Dynamic Attribute1 name.

[rushikeshvartak]

can you share config screenshot and logs

[Je]

Hi rushikesvartak,

Attribute1

Attribute Name: VaultName

Attribute Label: Vault Name

Attribute Type: String

Value: 

Parent Attribute: 

What action to perform when Parent attributes changes: 

Attribute2

Attribute Name: Generate

Attribute Label: Generate AD Group Name

Attribute Type: Single Select From SQL Query

Value: select 'Yes' as ID

Parent Attribute: 

What action to perform when Parent attributes changes: mapping

Attribute3

Attribute Name: GroupName

Attribute Label: Group Name

Attribute Type: Single Select From SQL Query

Value: select concat ('Vault_', ${VaultName}) as ID

Parent Attribute: Generate

What action to perform when Parent attributes changes: mapping


Basically, Attribute1 is where data will be fetched. Attribute2 is the bridging one (based on the solution offered on the link). Attribute3 is expected to display the outcome "Vault_(Value from Attribute1)"

[rushikeshvartak]

It works well with me 

[Je]

Hi Rushikeshvartak, Thanks. I appreciate you trying it out for me but for some reason, I do not know how to move forward with this. From my end, the Group name only generates "Vault_". The problem might not be with the query itself but thanks. 

[rushikeshvartak]

change mapping to Mapping also make sure order index matter

[Je]

Since you have mentioned, I've been trying to understand order index but I can't find anything useful. Aside from those three attributes, there are a few more that composes everything (11 attributes in total). I usually label each attributes (base on the order I want them to appear) from 1 then it increments to the next attribute. (att1 = 1, att2 = 2...). Can you enlighten me on it or if you have any good reference that I can check out?