Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

restricting project's in project name filter

Highlighted
saiskt
Regular Collector

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
Esteemed 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
Regular Collector

Re: restricting project's in project name filter

It worked great.Thank you very much.
//Add this to "OnDomLoad" event