Selecting a reference user to copy its products assigned does not show all the assigned products of the user

I have looked at the code for the component I mentioned. Currently the application roles are not loaded in the PersonInBaseTree collection. That's probably why those AERoles are not being displayed.

I will create a backlog item to also include AERoles in that view.

If you want to give it a try, look up the part where the WHERE clause includes:

"UID_OrgRoot in ('QER-V-Locality', 'QER-V-Department', 'QER-V-ProfitCenter')"

and change that value to

"UID_OrgRoot in ('QER-V-Locality', 'QER-V-Department', 'QER-V-ProfitCenter', 'QER-V-AERole')"

But other requestable products which I had added in MultiRequestable product, MultiRequestable/Unsubscribable products are also not there in the list. These products does not provide any entitlement to the user but in some cases it just inserts the data in Person table. So, will these products not come in the list of reference user?

ok and I noticed one more query which might be causing the issue. Below is the query to get uid_accproduct

string _tmpstring = "({0}) and uid_accproduct in ( select p.uid_accproduct from QER_VPWOProductNodes p" +
" join personhasobject pho on pho.ObjectKey = p.ObjectKeyOrdered where pho.UID_Pe" +
"rson = {1})";

Here in QER_VPWOProductNodes table, the objectkey of the product is different than the objectkeyordered in personhasobject table (this is for custom roles which were created). Other multirequestable/unsubscibable products does not come in the list as these are not even available in PersonHasObject table. Is it possible to show at least the custom application roles in the list?

Hi Hanno,

Can you please confirm if multirequestable products will come in the list of reference user or not? Thank you

Be sure that recipient you've selected is a member of the ITShop where products belongs to. Also multirequestable products are shown on the list. In Web Designer go to webproject, itshop,selectable reference employees and be sure that the value is 1=1 , aslo check filter for requests which can be copied from a reference employee

have you tried my suggestion above to show the application roles?

I can confirm that multirequestable/unsubscibable resources (QERReuseUS) are not displayed as they are not part of PersonHasObject.

Is it possible to do customization for this and show these resources in the list?

Yes, you can customize the WHERE clause that you already identified. Use Web Designer extensions to define a new WHERE clause.

selectable reference is set to "1 = 1" still custom application roles, multirequestable products are not visible in the list. I think the problem is it uses below query to get the users and their roles

string _tmpstring = "({0}) and uid_accproduct in ( select p.uid_accproduct from QER_VPWOProductNodes p" +
" join personhasobject pho on pho.ObjectKey = p.ObjectKeyOrdered where pho.UID_Pe" +
"rson = {1})";

now in case of multirequestable products, entry does not go in PersonHasObject table when the user requests for multirequestable products and in case of custom application role, objeckey in personHasObject table and ObjectKeyOrdered in QER_VPWOProductNodes do not match. What can be the solution for this?