Technical Rule advanced query

[user228]

Hello,

how can I write an advanced query where users.customproperty1  = entitlement_values.ENTITLEMENT_VALUE

and

users.costcenter=entitlement_values.customproperty3

I tried to write a where clause query but I think it has smth to do with case sensitivity that is why it is not working.

Thank you!

[naveenss]

Hi @user228  can you please elaborate on your requirement?

[user228]

yes, our requirement that is these 2 values are equal user receive an account in the specific target system

[naveenss · Accepted solution]

@user228 use like below

a.firstname= (select ev.entitlement_value from Entitlement_values ev where ev.entitlement_value='TestEntTechnicalRule')

Let me know if this helps. You can add anymore conditions in the similar format. 

[user228]

thank you! it worked! do you know if we can write the same condition in the SAVCUSTOMQUERY ?
so like SAVCUSTOMQUERY::ev.entitlement_value = '${users.firstname} ?