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

Multi-Select Portlet filter filters on a multi-select concatenated column.

SOLVED
Go to solution
Highlighted
Mahen M
Honored Contributor

Multi-Select Portlet filter filters on a multi-select concatenated column.

I want to have 'Project Manager'(multiselect) as a filter field for a portlet.

It filters based on 'PRJ_PROJECT_MANAGER_USER_ID' column values of 'kcrt_fg_pfm_project' table.

The pattern of 'PRJ_PROJECT_MANAGER_USER_ID' is '30120#@#33146#@#31735#@#31909'

I know this can be achieved with a PL/SQL Function and a temp type table.

I am looking for all possible solutions, If you have solved this, Kindly share us the solution.

Regards,
Mahendran M
5 REPLIES
B Swanson
Regular Collector
Solution

Re: Multi-Select Portlet filter filters on a multi-select concatenated column.

I do this with:
AND PM_UTILS.is_project_manager_id_in_list(v.PM_ID,replace('[P.P_PROJ_MGR]',',','#@#')) = 'Y'

where v.PM_ID is the list of project manager user IDs from the DB.
shygirl
Regular Collector

Re: Multi-Select Portlet filter filters on a multi-select concatenated column.

i am using something like this
--> AND INSTR([P.P_PROJ_MGR],kfpp.prj_project_manager_user_id)>0

where kfpp.prj_project_manager_user_id is the column in kcrt_fg_pfm_project (kfpp) table

Re: Multi-Select Portlet filter filters on a multi-select concatenated column.

Hi,

other possible solution:

AND '#' || PRJ_PROJECT_MANAGER_USER_ID || '#' LIKE '%#' || [YOUR_TOKEN]' || '#%'

I havn't test it in this case but should work

Regards
Volker
Mahen M
Honored Contributor

Re: Multi-Select Portlet filter filters on a multi-select concatenated column.

Thanks guys, Swanson, I like the OOTB usage of function, Still a lot to learn :-))

regards,
~ Mahen

Regards,
Mahendran M
Abdullah Rafiq
Regular Collector

Re: Multi-Select Portlet filter filters on a multi-select concatenated column.

hello everyone,
I have a similar problem ..
what would you do for a custom field which is a multi-select on a request type and the portlet also allows the user for a mutli-select ....

In this case the and statement would be as follows

and ('value1#@#value2') in ('value1#@#value3#@#valueXX')

As you can see, this doesn't work, even if instead of the 'IN' I use a 'LIKE' ... is there a way to use mutli-select filter for a multi-select field?

Please advise.
Thanks in advance!
//Add this to "OnDomLoad" event