Hello,
I have written below sql query in entitlement rule to get missing app roles on request form. But I am getting duplicate entitlements from all business sources instead of one approle which is there in T_AV_ROLE_MISSINGENTS table.
select DISTINCT r.name from T_AV_ROLE_MISSINGENTS me,t_entitlement_groups r,PV_APPLICATION a
where r.id=me.ENT_ID and a.id=r.APPLICATION_ID and me.MEMBER_ID=43987;
Kindly suggest , How can I achieve this solution.
Not sure if possible, but can you try something like:
x."Entitlement Type"='app-role'
and x.ENTITLEMENT_ID in (select DISTINCT r.id from T_AV_ROLE_MISSINGENTS me,t_entitlement_groups r,PV_APPLICATION a
where r.id=me.ENT_ID and a.id=r.APPLICATION_ID and me.MEMBER_ID=43987)