Hi,
We are facing an issue where Role Ownership Transfer is not working when Advanced query is used in User update rule.
When we use simple condition in user update rule like below, it works as expected and replaces role owner on user disablement. but this rule will trigger for everyone who becomes inactive, hence we want to use advance query for better performance so that rule will trigger for the users who becomes inactive and are actually role owners and will send out Ownership Transfer emails to New Owners.
But when we use advance query like below, it is not working at all:
((##a.statuskey isupdated##) and a.statuskey = '0' and a.customproperty24 = 'Workday' and a.email like '%abc.com%' and a.username in (select u1.username from Users u1, role_owners ro1, roles r1 where u1.id=ro1.userkey and r1.id=ro1.rolekey))
Error we get : org.springframework.orm.hibernate3.HibernateQueryException: role_owners is not mapped
We already have a user update rules for endpoints and entitlements with below advance query and they are working fine:
Entitlement Ownership Transfer:
((##a.statuskey isupdated##) and a.statuskey = '0' and a.customproperty24 = 'Workday' and a.email like '%abc.com%' and a.username in (select u1.username from Users u1,Entitlement_owners eo1,Entitlement_values es1 where u1.id=eo1.userkey and es1.id=eo1.entitlement_valuekey))
Resource Ownership Transfer:
((##a.statuskey isupdated##) and a.statuskey = '0' and a.customproperty24 = 'Workday' and a.email like '%abc.com%' and a.username in (select u1.username from Users u1,Endpoints ep1 where u1.id = ep1.requestowner))
We had raised a Support FD Ticket:
2014513 where the agent informed that
Role_owner table is not exposed in advance query and hence we also raised an Idea to expose the same in advance query: EIC-I-5444 , Please upvote the idea.
Although this Saviynt Post talks about HQL table names, but it doesnt mentions role_owners table, But I tried following camel case rule for HQL i.e Role_owners, but received the same error: Role_owners is not mapped
Could you please help us here with alternate approach/ solution
Thanks,
Dhiraj Yadav
