Requestable entitlement query is not working properly based on dynamic attribute value selection

[saramohanraj]

Hi, We have set of entitlements that needs to be listed based on the dynamic attribute value populated.

The dynamic attribute value is autopopulated type and not based on selection. It basically have 2 values 'admin', 'user'. The customproperty40 of the entitlements holds this values as follows

A -'Admin'

B-'User'

C-'Admin,user'. 

We have used the following requestable query in the entitlement type ev.customproperty40 like '${dynamicattr}%'.

When the cp40 value is Admin, it should display A, C when cp40 is user, it should display B,C

But the problem is, it is displaying all the entitlements A, B, C irrespective of the cp40 value. The query returns proper value in DA. but not in ARS entitlement page. 

Can someone help what am I missing here?

[rushikeshvartak]

User needs to select one time. Remove default value config from dynamic attribute

[saramohanraj]

No, We don't want this to be selected in UI. So we have made it non editable, and based on the requestor's profile, it will be auto populated. It has only 1 value in UI, but not populating the entitlements based on the value that is auto populated. Any other way to achieve this?

[rushikeshvartak]

It won't work , User need to select 

[rushikeshvartak]

How dynamic attribute value is prepopulated based on what user's field can you share query

[saramohanraj]

I have used limit in the query to populate. 

Select 'Admin' as ID From Users u join user_accounts ua on u.userkey=ua.userkey join accounts a on a.accountkey=ua.accountkey join account_entitlements1 ae on ae.accountkey=a.accountkey where ae.entitlement_valuekey='611798' and u.userkey='${requestor}' union Select 'User' as ID limit 1

[saramohanraj]

If its not possible in entitlements, is it possible in roles? Can you please provide with some sample queries to be used in request query in roles type?

[rushikeshvartak]

r.status=1 and r.customproperty10='${DYNA}'

[rushikeshvartak]

So what happens if user does not have that entitlement 

[saramohanraj]

It populates 'user' in the dynamic attribute

[rushikeshvartak]

What happens when user selected manually. it will work as expected.

[saramohanraj]

I tried with manual selection as well, it is not working either.

[rushikeshvartak]

Entitlement filter query

[saramohanraj]

Tried below

ev.customproperty40 like '${dynatttr}%'
ev.customproperty40 like '%${dynatttr}%'