• State Not Answered
  • Locked Locked
  • Replies 21 replies
  • Subscribers 95 subscribers
  • Views 6539 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

ruchita.mantri
over 6 years ago

Hi,

When I am trying to raise a request using "select reference user", it is not showing all the requested and assigned products of this user. What might be the cause for this? Please help

Parents
  • 0 over 6 years ago

    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

  • 0 over 6 years ago in reply to lerodriguezdiez

    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?

Reply
  • 0 over 6 years ago in reply to lerodriguezdiez

    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?

Children
No Data