HQL Query - Correct table name

[prachi]

Hi,

We are trying to use the below HQL query in the "Config for Requestable Entitlement in ARS" , but its throwing error with table - user_Groups 

ev.entitlement_value IN (select ug.user_groupname from user_Groups ug,usergroup_users ugu where ug.id=ugu.user_groupkey and ug.user_groupname like '%ALL' and ugu.userkey =${requestee})

I have tried all formats like - user_Groups , user_groups , User_Groups , User_groups.

Could anyone help with the correct syntax for this table?

Thanks

[NM]

@prachi you can't use usergroups table under config for requestable entitlement in ARS.

[pmahalle]

Hi @prachi ,

You can use only entitlement_values table in Config for Requestable Entitlement in ARS. Other tables are can not be used. 

In case you want some custom logic to show entitlements on ARS, create dynamic attribute and use it filter out the entitlements on ARS.

[prachi]

If i have two values returning from user group which i want to use here, how do i get the values from dynamic attributes?

[rushikeshvartak]

I have used user group under entitlement refer below

(1=(SELECT count(*) FROM Usergroup_users ugu WHERE ugu.user_groupkey=31 and ugu.userkey = ${requestee}) ))

[prachi]

You have used "Usergroup_users" in the query shared above.

Did you also use table - user_Groups ? I have issue with table - user_Groups  table..

[naveenss · Accepted solution]

Hi @prachi use the below query

ev.entitlement_value IN (select ug.user_groupname from Usergroups ug,Usergroup_users ugu where ug.id=ugu.user_groupkey AND ug.user_groupname like '%ALL' AND ugu.userkey =${requestee})

[rushikeshvartak]

I have hardcoded key of usergroup

(1=(SELECT count(*) FROM Usergroups ug,Usergroup_users ugu WHERE ug.id=ugu.user_groupkey AND ug.user_groupname='RUSHI' and ugu.userkey = ${requestee}) ))