Project and Portfolio Management Practitioners Forum
cancel

restricting project's in project name filter

Highlighted
saiskt
Respected Contributor.

restricting project's in project name filter

Hi, I added a project name filter in a report but when the user is trying to select values, the filter is showing all the project values. Instead I want the filter to show only the projects related to that userid.Is there any way to build such logic? Please let me know if my query is not clear.
2 REPLIES
Sascha Mohr
Acclaimed Contributor.

Re: restricting project's in project name filter

You will need to have a line like this in your validation:
AND (SELECT PM_UTILS.Can_User_Access_Project([SYS.USER_ID], project_id) FROM DUAL) = 'Y'
saiskt
Respected Contributor.

Re: restricting project's in project name filter

It worked great.Thank you very much.