Project and Portfolio Management Practitioners Forum
cancel

Custom Portlet

Highlighted
Gary Rubinstein
Respected Contributor.

Custom Portlet

I have writen a custom portlet that lists a bunch of information and I am finding that when I try to add the Sponsor in the portlet it filters out all of those items that do not have a Sponsor against the request item.

I have attached the sql I am using for the portlet and would appreciate any feedback on what I have missed.

Thanking you in advance,
Gary
2 REPLIES
Semenov Alexand
Acclaimed Contributor.

Re: Custom Portlet

Hi Gary.
I copy standart data source and add custom filter. All work correct. I attached screen for you help.
Good Luck
Erik Cole
Acclaimed Contributor.

Re: Custom Portlet

Hi Gary,

I think you just need to change your join to knta_users to an outer join:

AND rhd.visible_parameter20 = users.username(+)