Filtering account on basis of privileged entitlements

[Ajit]

Hi Team, We are trying to filtering the account under application owner campaign and we are utilizing the advanced query within the campaign feature with information as below accountquery --- status =1 EntitlementQuery---status=1 and (privileged=0 or privileged='' or privileged is null) Account Entitlements1 Query --- ae1.entitlement_valuekey.privileged is null or ae1.entitlement_valuekey.privileged='' or ae1.entitlement_valuekey.privileged=0 After saving the campaign it is throwing error in the log invalid query for accountenttlement1 table as below <------ 2023-06-07T04:47:58.623752517Z stdout F 2023-06-07 04:47:58,623 [http-nio-8080-exec-102] DEBUG services.SaviyntCommonUtilityService - HQL Query - Select count(*) from Account_entitlements1 ae1 where ae1.entitlement_valuekey.privileged is null or ae1.entitlement_valuekey.privileged='' or ae1.entitlement_valuekey.privileged=0 2023-06-07T04:47:58.639579437Z stdout F 2023-06-07 04:47:58,639 [http-nio-8080-exec-102] ERROR services.SaviyntCommonUtilityService - could not resolve property: privileged of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [Select count(*) from com.saviynt.ecm.identitywarehouse.domain.Account_entitlements1 ae1 where ae1.entitlement_valuekey.privileged is null or ae1.entitlement_valuekey.privileged='' or ae1.entitlement_valuekey.privileged=0]; nested exception is org.hibernate.QueryException: could not resolve property: privileged of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [Select count(*) from com.saviynt.ecm.identitywarehouse.domain.Account_entitlements1 ae1 where ae1.entitlement_valuekey.privileged is null or ae1.entitlement_valuekey.privileged='' or ae1.entitlement_valuekey.privileged=0] ------> It seems like privileged attribute is not accessible using the accountentitlement1 query. Please let us know the alternate ways or solution to filter the account for this critical use case

[nimitdave]

Please try with below:

Account Entitlements1 Query --- ae1.entitlement_valuekey.priviliged is null or ae1.entitlement_valuekey.priviliged=0

[Ajit]

Hi Team,

we tried with the Account Entitlements1 Query: 

(ae1.entitlement_valuekey.priviliged =0 or ae1.entitlement_valuekey.priviliged is null or ae1.entitlement_valuekey.priviliged ='')

But this also didn't work out.

[nimitdave]

dont use ae1.entitlement_valuekey.priviliged =''

only use :

ae1.entitlement_valuekey.priviliged is null or ae1.entitlement_valuekey.priviliged=0