Importing owner ranks using ENTITLEMENTVALUEIMPORT

[RoniYla]

Hi,

I'm trying to implement a functionality that copies owners and their ranks from role -> entitlement_value.

I am able to import the owners to a entitlement using the following ENTITLEMENTVALUEIMPORT however the ranks are only being set to '1' at  the moment and we would need to copy the exact rank form roles.
<dataMapping>
<sql-query description="This is the Source Database Query">
<![CDATA[select 'Azure' AS 'applicationname', 'Azure' AS 'endpointname', u.username AS 'dataowner1', r.ROLE_NAME AS 'entitlementvalue', et.DISPLAYNAME AS 'entitlementtype' from users u, entitlement_types et, role_owners ro, roles r LEFT JOIN entitlement_values ev ON R.ROLE_NAME = ev.entitlement_value WHERE r.ROLEKEY= ro.ROLEKEY AND ev.entitlement_value = 'TestAADGroup' AND ev.ENTITLEMENTTYPEKEY= et.ENTITLEMENTTYPEKEY AND et.ENDPOINTKEY = (select ENDPOINTKEY from endpoints where endpointname = 'Azure') AND u.userkey = ro.userkey]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" deleteentitlementowner="false" entnotpresentaction="noaction" createentitlementtype="true" systems="SecSystemName">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="applicationname" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointname" type="character"/>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="entitlementvalue" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entowner1" sourceproperty="dataowner1" type="character"/>
</mapper>
</dataMapping>

Best regards,

Roni

[rushikeshvartak]

Owner Rank	variable	Syntax
1	entowner1	<mapfield saviyntproperty="entitlementvalues.entowner1" sourceproperty="dataowner1" type="character"/>
2	entowner2	<mapfield saviyntproperty="entitlementvalues.entowner2" sourceproperty="dataowner2" type="character"/>
3	entowner3	<mapfield saviyntproperty="entitlementvalues.entowner3" sourceproperty="dataowner3" type="character"/>
4	entowner4	<mapfield saviyntproperty="entitlementvalues.entowner4" sourceproperty="dataowner4" type="character"/>

if rank is one the entowner1 is variable and other entowner2 to 26 changes as per rank 

[Darshanjain]

Hi @RoniYla 

Can you please use the column as entowner5 ( if rank 5 has to be populated ).

Thanks

Darshan