Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Dynamic Attribute with SQL Concat deliver wrong user

aro
Regular Contributor
Regular Contributor

Hello,

we have a Dynamic Attributes "AccountType" in an Endpoint.

We need a second Dynamic Attribute of Attribute Type "Single Select From SQL" that should make a concat of the affected user and the value from the Dynamic Attributes "AccountType". This looks like this:

SELECT concat((Select username from users where userkey=${user.id}), ${AccountType}) as ID

But the "Select username from users where userkey=${user.id}" in the concat deliver the requestor not the affected user.

We have also created individual Dynamic Attributes for the affected user and the AccountType. These return the correct values. What is wrong?

aro_0-1671617542462.png

Example: The affected username ends with ...754, but in the concat the requestor ...610 is delivered:

aro_1-1671617643654.png

 

21 REPLIES 21

rushikeshvartak
All-Star
All-Star

Select concat(username,' ',${AccountType}) as id from users where userkey=${user.id}


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

No, also with this new select we get the requester and not the affected user.

I validated this on my end and what I noticed is if I am not configuring parent attribute then it is pulling correctly but once you configure parent attribute then it is pulling wrong information. So I assume either it is bug or there might be different parameter to use when parent attribute configured.

sk_0-1671660711503.png

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee.id}


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

I do not get any result (No Options) with this SQL:
     Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee.id}

KirtiAjrot
Saviynt Employee
Saviynt Employee

If the one shared by rushikesh is not working , you cold try with the below. 

select concat(username,' ',${parent}) as id from users where userkey='${REQUESTEE}'

However ,if this is not working , please work with the Saviynt Ops team via an FD ticket. 

KA

     Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee}

 

rushikeshvartak_0-1671720960700.pngrushikeshvartak_1-1671720975273.png

 

Working exmaple

rushikeshvartak_0-1671722341513.pngrushikeshvartak_1-1671722360601.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

ASA
Regular Contributor II
Regular Contributor II

We've tried that. We  have now

Select username as id from users where userkey=${requestee}

 and

Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee}

First one results in username of requestee, second one still resolves to username of requestor.

Had another idea and tried to make the table reference explicit:

Select concat(ru.username,' ',${AccountType}) as id from users ru where ru.userkey=${requestee}

which also doesn't work. We will open a ticket now.

 

Which request form ?

normal account or service account 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

normal account

Share screenshot from

endpoint - dynamic attribute 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

You can find the endpoint - dynamic attribute screenshots in the topic description

Its old csn you provide with latest query 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

aro_1-1672675474748.png

 

 

Do you see any error while form is loading ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

No

try keeping concat('1','2') 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

That works:

select concat('1','2') as id

and also that:

Select concat('Text1',' ',${AccountType}) as id

${requestee.username}


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aro
Regular Contributor
Regular Contributor

not working

raise freshdesk ticket


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.