Using entitlement_values table in consult query for entitlement owner campaign

[rahul_p]

Hello,

We want to show consult query by using Users, Entitlement_owners and Entitlement_values tables.

We are using following query :

select u from Users u where 1=1 and u.id in (select eo.userkey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo where eo.entitlement_valuekey in (select ev.entitlement_valuekey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.description like '%DVH%'))

We want to show the entitlement owner which is satisfying some criteria like having some specific word in entitlement description.

For above query, getting below error :

ERROR services.SaviyntCommonUtilityService - could not resolve property: entitlement_valuekey of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values

nested exception is org.hibernate.QueryException: could not resolve property: entitlement_valuekey of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values

Please comment if you have any idea about how to refer entitlement_values table in consult query for entitlement owner campaign

Regards,

Rahul

[sudeshjaiswal]

Hello @rahul_p,

Can you please explain more about use case and query you have written?

Thanks,

[Rajesh-R · Accepted solution]

@rahul_p 

Could you please try the following?

select u from Users u where 1=1 and u.id in (select eo.userkey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo where eo.entitlement_valuekey in (select ev.id from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.description like '%DVH%'))

[rahul_p]

Hello @Rajesh-R ,

Your query is working and thank you for that.

Is there any document to formulate such query? how come we decide that where to use actual key or just id?

Regards,

Rahul

[Rajesh-R]

@rahul_p

The primary key of the table is referred as id.