AnsweredAssumed Answered

How to filter out apps from business source picker where user does not have account?

Question asked by Zoltan Izsak on Jul 14, 2017
Latest reply on Jul 17, 2017 by Marek Lotocki
  • Comment • 1

I want to implement a "change branch_code" function. Branch codes are entitlements with own type. I tried to use "change using request sources" button but it sends me to a form default application form where it is not possible to display only entitlements with attribute "branch code".

My next idea is custom form but in the business source picker I was not able to filter for business sources where the user has account or any access right. Any idea how to do this? Or any workaround?

 

Regards,

Zoltan

Marek Lotocki
Marek Lotocki Jul 17, 2017 5:12 AM
Correct Answer

Hi Zoltan,

 

you can use "Business Source Filter" on "Business Source Picker" like below

apps.Name IN 
(SELECT app.NAME FROM T_APPLICATIONS app WHERE 
app.ID IN (SELECT acc.APPLICATION_ID FROM T_AV_ACCOUNTS acc WHERE 
acc.ID IN (SELECT map.ACCOUNT_ID FROM T_AV_USER_ACCOUNT_MAPPINGS map WHERE 
map.USER_ID IN (SELECT usr.ID FROM PV_USERS usr WHERE 
usr.USER_ID IN ('${avform.user.User_Id}')))))
See the reply in context
No one else had this question

Outcomes

    Visibility: RSA Identity Governance & Lifecycle72 Views
    Last modified on Jul 14, 2017 12:29 PM
    Ratings: