Filtering one table based on multiple selections from another table in Portal Page

Flow Connect
1

Hi,

I’m trying to use multiple selections from one table as an input filter for another table in a Portal Page in Flow Connect, and I’m wondering if this is possible. My scenario is the following:

  • The first table contains a list of warehouses.

  • The second table contains order lines.

  • I would like the user to select multiple warehouses in the first table, and then have the second table automatically filtered to show only the order lines that belong to the selected warehouses.

The reason I’m trying to implement it this way is because multiple selection in an LOV is not supported, so I’m attempting to achieve the same functionality using a table instead. Is it possible to pass multiple selected rows from one table as a filter parameter to another table in a Portal Page?

Any suggestions or examples would be greatly appreciated.

Thanks!

2

Hi, sounds like what you are after is a dependent list of values? Try this:

image
image1239×667 54.5 KB

3

Hi,

In my scenario, this would involve selecting multiple values from the list, which should act as an “OR” condition. For example, Order Lines belonging to warehouse 011 or 014 should be displayed. To my understanding, this is not possible when using a LoV in the Filter portlet, correct? Therefore, I considered using a Table portlet with a multi-selection option instead and linking it to the Order Lines table. The idea would be something like the example shown below.

  1. Is that achieveble by any ‘standard’ portlet?
  2. Is there a plan to enhance Filter’s LoV to support that feature?

image
image554×633 48.9 KB

thanks for reply.

4
  1. I do not think so, unfortunately. Yet
  2. There is. I think in Q2 or Q3. But please create a feature request so that we get all pionts of view in when we look at it
5

Yes, I will.

Thanks for confirming the above.