Project and Portfolio Management Practitioners Forum
cancel

Multi-select filter against a multi-select field

Highlighted
pepdwill
Honored Contributor.

Multi-select filter against a multi-select field

Does anyone have a good solution they can post for defining a multi-select filter (assume within a data source definition for use in a portlet) for a multi-select field?

 

If anyone has a SQL solution they'd be willing to post it would be greatly appreciated.

 

Thanks -

Danny

1 REPLY
Franatucha
Respected Contributor.

Re: Multi-select filter against a multi-select field

Hi!

I usually apply the next method to resolve multi-select filters vs. multiple results.
For example, I got a Tasks Lists that I need to filter by Resource. Resources in a Task can be multiple results.

 

 

 

RESOURCE_LIST is a Concatenated (wm_concat function in SQL) list of the resources of a task.
The validation is a SQL wich returns all FULL_NAME of the resources of a Resource Pool.

So, here you're selecting TASK_ID wich resources are filtered in the subquery.