and more in a single search tool across platforms. Read the announcement here. |
on 04/03/2023 09:40 PM
Scenario:
All
We can use advanced dynamic attribute logic for username generation like below
select concat("OW",case when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 1) then concat('00000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 2) then concat('0000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 3) then concat('000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 4) then concat('00', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 5) then concat('0', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) END) AS ID from request_access_attrs raa,users u where raa.attribute_name = 'Username' and raa.attribute_value like 'OW0%' and u.username like 'OW0%' and length(u.username) = 8
@sudeshjaiswal can you please let me know what advanced dynamic attribute logic?