Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/17/2024 09:45 PM
Hi We have two dynamic attributes in ARS page while requesting for the account.
where 1st attribute will give the account name which is a substring of one of the user's customproperty.
where 2nd attribute will give the number to append if the account name is already exists
is it possible to utilize the 1st attribute result in the 2nd attribute where we are utilizing the saviynt users tables not the data set?
1st Attribute Name: mainAcc
this is the first query:
SELECT SUBSTRING( SUBSTRING_INDEX( customproperty6, '@', 1), 1, 15) AS ID from users WHERE userkey = ${requestee}
2nd Attribute Name: suffixPart
Parent Attribute: mainAcc
what action when parent attribute changes: Mapping
this is the second query:
SELECT ( SELECT COUNT(*) FROM ( SELECT userkey FROM users WHERE customproperty6 LIKE CONCAT(${mainAcc} , '%') ORDER BY userkey ) AS t WHERE t.userkey <= users.userkey ) AS ID FROM users WHERE userkey = ${requestee} ORDER BY userkey;
why this is not populating the value and throwing error. we can't utilize the parent attribute in Saviynt tables?
06/19/2024 02:18 AM
Hello @Mahendran,
Seems there is issue with the second query , please validate.
Thanks.