AnsweredAssumed Answered

How to get unique entitlements on request form using SQL query 

Question asked by Muneendra Sriram on Dec 18, 2018
Latest reply on Dec 21, 2018 by Mostafa Helmy

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.

Outcomes