AnsweredAssumed Answered

User Picker & Changes Applies To

Question asked by Sabthami S on Sep 27, 2017
Latest reply on Sep 28, 2017 by Daniela Nicolai

Hi All,

 

The Use case here is to Create a Request Form to request for Roles.In the Form we have one User Picker and 2 Entitlements table.Basically when a requester (Role Owner/Supervisor ) request a Role for a user by selecting the User in User Picker,the First Entitlement table will show the list of Parent entitlement the selected user holds and the second entitlement table will be showing the child roles associated with the parent role selected in first entitlement table which the selected user does not have.

 

Below are the query which I m using in Entitlement Rules option

 

Parent Roles: 

x."Entitlement Raw Name" IN (select "Role Name/Entitlement" from PV_USER_ALL_ACCESS where Type in ('global-role')
AND "Is Parent"='Yes' AND ENTITLED_ID IN (select ID from PV_USERS where USER_ID='${avform.requestor.User_Id}'))

 

Child Roles: 

x."Entitlement Raw Name" NOT IN (select "Role Name/Entitlement" from PV_USER_ALL_ACCESS where Type in ('global-role')
AND ("Is Parent"='No' OR "Is Parent" Is NULL) AND ENTITLED_ID IN (select ID from PV_USERS where USER_ID='${avform.requestor.User_Id}'))

 

So what happens is when we submit the form it creates Change Request with out any details captured the User/Roles details.It simply creates a blank request.

 

In Change Request applies to option in Form  don't have any option to associate the user selected in User Picker.Is there any other way to achieve the above use case ?

 

Any help is much appreciated !!! Many thanks !!!

 

Regards,

Sabthami Subramanian

Outcomes