and more in a single search tool across platforms. Read the announcement here. |
12/21/2022 02:20 AM
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?
Example: The affected username ends with ...754, but in the concat the requestor ...610 is delivered:
12/21/2022 10:02 AM
Select concat(username,' ',${AccountType}) as id from users where userkey=${user.id}
12/21/2022 01:53 PM
No, also with this new select we get the requester and not the affected user.
12/21/2022 02:13 PM
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.
12/21/2022 03:18 PM
Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee.id}
12/22/2022 12:27 AM
I do not get any result (No Options) with this SQL:
Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee.id}
12/22/2022 06:27 AM
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.
12/22/2022 06:56 AM - edited 12/22/2022 07:19 AM
Select concat(username,' ',${AccountType}) as id from users where userkey=${requestee}
Working exmaple
12/23/2022 05:58 AM
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.
12/23/2022 06:01 AM
Which request form ?
normal account or service account
01/02/2023 03:21 AM
normal account
01/02/2023 04:25 AM
Share screenshot from
endpoint - dynamic attribute
01/02/2023 05:37 AM
You can find the endpoint - dynamic attribute screenshots in the topic description
01/02/2023 06:08 AM
Its old csn you provide with latest query
01/02/2023 08:04 AM
01/02/2023 08:09 PM
Do you see any error while form is loading ?
01/03/2023 01:06 AM
No
01/03/2023 04:45 AM
try keeping concat('1','2')
01/03/2023 06:17 AM
That works:
select concat('1','2') as id
and also that:
Select concat('Text1',' ',${AccountType}) as id
01/03/2023 06:48 AM
${requestee.username}
01/03/2023 09:25 AM
not working
01/03/2023 05:54 PM
raise freshdesk ticket