Config For Available Entitlement In Service Account

[Mortal]

Hi,

Working on the Service Account Request form, for the Config For Available Entitlement In-Service Account I was not able to configure it using the documentation query.

"{"Service Account": "ev.customproperty1 in (select city from Users where userkey=${requestor})", "Functional Account": "ev.customproperty2 in (select title from Users where userkey=${requestor})"}"

I need to get the entitlements whose name starts like IGA_DATA so I rewrote the query with {"Service Account": "ev.entitlement_value like %IGA_DATA%"} but was unable to get those entitlements on the service account request page. Need help with this

[NM · Accepted solution]

Hi @Mortal , try this

"Service Account": "ev.entitlement_value like '%IGA_DATA%'"} 

[Mortal]

Thank you @NM 
the query worked and I was able to get the filtered entitlements.

[rushikeshvartak]

Just to update query was missing start {
Final query

{"Service Account": "ev.entitlement_value like '%IGA_DATA%'"}