Access Query is failing while requesting access from ARS using Request Access for others - Multi use

[harishyara]

Hello Everyone,

Facing below 2 issues

Issue1 - Access Query is failing while requesting access from ARS using Request Access for others - Multi user tile

Explanation - We have two endpoints EDP1 and EDP2. Requestor is requesting an access to multiple users for EDP2 (let say 2 users using Request Access for others - Multi user tile). EDP2 endpoint has an Access Query and it's logic is to check users EDP1 account should be Active then only EDP2 should be visible to add it to cart. When requestor trying to request access for those two users, Access Query is failing hence it is showing EDP2 in the List to add it to card which is not correct.

Please confirm if this is the issue with product or is there any way that we can fix this issue?(We are currently using v5.5SP3.) 

Note - From the same tile using Request Access for others - Multi user if requestor is trying to submit access request for bulk users using CSV import for same EDP2 then the Access Query was working fine.

Issue2 - Since we are taking about Request Access for others - Multi user we have another issue here where if user is already having an active account for EDP1 when requestor goes to Request Access for others - Multi user tile and search for that EDP1 it is showing Add to cart instead of Modify Account label 

Please assist here @rushikeshvartak 

Regards,

Harish

[naveenss]

Hi @harishyara ,

can you share the access query you are using in this case? Also did you see any error in logs?

[harishyara]

@naveenss This is the Access Query

Access Query of EDP2

where users.userkey in (select distinct ua.userkey from user_accounts ua, accounts a where ua.accountkey=a.accountkey and a.endpointkey=1(this is endpointkey of EDP1) and a.status IN ('1', 'Active', 'Manually Provisioned'))

Regards,

Harish