ARS - Dynamic Attributes - SingleSelect - AutoSelect if only one value is retured by the query

[Community_User]

Originally posted on November 15 2021 at 18:59 UTC

 Hello Saviynt Team,

In ARS, We want to autoselect the value for Single Select Dynamic Attribute when the SQl query ( Attribute "value" of Dynamic attribute ) return only one row.

Is that possible ?

Thank you !!

Regards,

SANSOUCY Martin

[Community_User]

Originally posted on November 18 2021 at 21:36 UTC

Hi Sansoucy Martin, 

I dont think that is possible since the output of the SQL is always in the dropdown and not auto selected as default.

Regards,

Avinash Chhetri

[Community_User]

Originally posted on November 19 2021 at 19:04 UTC

Hi,

You can copy and paste the SQL query in the "Default Value" of your dynamic attribute. If the query retrieves one value, it should be automatically filled in.

Regards,

Adrien COSSON

[Community_User]

Originally posted on November 22 2021 at 16:01 UTC

 Thank you for your answer Adrien.

I am using dynamic attributes in the SQL Query.

And seems dynamic attributes are not allowed in "Default Value".

Can someone confirm this ?

Thank you,

Regards,

SANSOUCY Martin

[Community_User]

Originally posted on November 22 2021 at 19:01 UTC

Hi Martin,

I believe this might be a small glitch in the UI.

Please try to proceed like below :

• Save your SQL query in a notepad.
• Switch your dynamic attribute to a type that let the "Default Value" available (e.g : Enum)
• Switch back to SQL query and paste you query.

Hope this helps.Regards,Adrien.

[Community_User · Accepted solution]

Originally posted on November 30 2021 at 16:08 UTC

 Thank you Adrien.

Default Value was visible for me on a dynamic attribute with "Single Select SQL Query" type.

We are in 5.5 SP3. We had open a Ticket for this and Saviynt told us, this issue is fixed in last version of saviynt.

[Community_User]

Originally posted on March 22 2022 at 20:01 UTC

We did something similar with the register user form. It appears that the default value will select the single result, but it will not map that value to the user record when the form is submitted. Thus, we have to make our users click the drop down and actually select the single result. I have not tested this with ARS to see if the behavior is the same.

[Community_User]

Originally posted on March 23 2022 at 12:21 UTC

Same For us, if single result is returned by the query then it was autoselected, but entitlement type filter was (and still is) not working.

We have added None in the dropdown list using an UNION query ( SELECT 'None' as ID UNION SELECT ....) to force the user to select the Value and make the filter work :