Skip to main content
Question

Limit Requests primary list by department of current user

  • 4 September 2024
  • 2 replies
  • 17 views

I need to limit Requests view so employees can see their own Requests or those of employees in their department (field on Request). 

I can easily limit users to their own requests using RQRequests.CreatedByID = @Me in the GI condition. But I need the equivalent of “Or RQRequests.DepartmentID = @Me” . Problem is, @Me doesn’t work for DepartmentID field. 

Does anyone know how I can accomplish this?

You need to join PX.Objects.EP.EPEmployee and create RELATIONS & CONDITIONS as shown in the screenshots below.

 

 

 

Best Regards,

NNT

@nhatnghetinh Thanks for the response. I don’t think this will work though. For the Employee join (and in turn Department condition), employee is the requestor. But I need user who is not requestor to see Requests if they are in the same department. 

For example, Jane Doe in FINANCE department submits a request. I am not Jane Doe, but I am in FINANCE department. When I log in, I need to see her requests. 

Your join would essentially be Jane = Jane, and in turn the condition would be “Department on Request = Jane’s Department”. My department (as user logged in) is nowhere in the equation, and that’s the variable I’m trying to solve. 

Please let me know if I’m missing something. Thanks!

Reply


Terms & ConditionsCookie settings