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



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 from T_AV_ROLE_MISSINGENTS me,t_entitlement_groups r,PV_APPLICATION a

 where and and me.MEMBER_ID=43987;


Kindly suggest , How can I achieve this solution.