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

How to configure a multi-selct Portlet filter for multi-select Field.

Highlighted
Deep Mehta
Regular Collector

How to configure a multi-selct Portlet filter for multi-select Field.

Hi,

I am having issue configuring a portlet filter for a multi-select field. My batabase column contains more than 1 strings seperated by '#@#'. I want to display all entries matching my filter.
Appending AND TABLE.PARAMETER IN ([P.TOKEN.TO_STRING]) is not working for multiple entries in Database.
Has anyone configured these kinds before?

Thanks in advance,
Deep
6 REPLIES
Niraj Prabhu
Frequent Visitor

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Hello Deep,

You will have to write a function to extract data from database and compare outside in a function to come up with the desired output.

I believe you are comparing the multiple Project Manager field here.

Thanks!
Niraj
Niraj P.
Erik Cole
Honored Contributor

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Try

TABLE.VISIBLE_PARAMETER IN ('[VP.TOKEN.TO_STRING]')
Mahen M
Honored Contributor

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Hi,
Please find a reply which I got from HP Support.

"For this issue as it is a Custom SQL for a custom Portlet, Custom Portlets are not support.

I have checked our knownledge base and talked a senior support engineer, it does not look like we have any information on your question on how to include the multiselect filter whose source is also a multiselect field."

Niraj,
Can you explain more on this?

Regards,
Mahendran M
Linda Hauck
Regular Collector

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Hi Deep,

I use this for a multiple choice filter where there are multiple items stored in the field (det.visible_parameter6)and it works:

AND (select full_name from knta_users where user_id in '[P.PICK_OTHERS]') = det.visible_parameter6

Hope this helps.

Linda
Sascha Mohr
Esteemed Contributor

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Here is an example of a filter SQL that works with fields containing multiple values and filter setting with multiple values as well:

and instr(','||'[P.RESSORTS]'||',', ','||l.lookup_code||',') !=0

I don't know way, but here PPM sometimes (?)uses commas as separators even though it is the non-visible value.
kalaiarasan_1
Occasional Advisor

Re: How to configure a multi-selct Portlet filter for multi-select Field.

Hi Deep,

I think you can use the package knta_multi.contains. Let me know if this helps you.

See the below code which I am using in my portlet.

AND exists
(
select user_id
from knta_users
where knta_multi.contains(kfpp.prj_project_manager_user_id, user_id) = 'Y'
and user_id in ([P.PROJECT_MANAGER]))

Regards
kalai
//Add this to "OnDomLoad" event