Reference Filtering in Collections

Feedback & Ideas
1

issue was already already described - yes the headlines is already clear enough imo - in the past: Element in Collection Reference Row Filter

we still have no trivial way of Reference Row Filter and Reference Row Splitter to use e.g. a String Column as filter for a Collection column

String Column
AA
BB
CC

Collection Column
[AA, CC, DD, EE]
[AAAAA, BBBB]

[DD]
[BB, DD]

There are some subset matcher nodes but those serve a different purpose.

2

I agree, there isn’t anything out of the box that will do this filtering for you. How do you envisage such a row filter working? Would it be to find rows that contain all of the elements in the reference table, or any single element, or other options?

It was for my own fairly regular need to inspect the content of collections in the past - which as you say is non trivial - that I wrote my Collection Inspection component:

It doesn’t provide the full “reference” functionality that you mention, but can assist.

image
image1743Ă—818 171 KB

See the demo workflow that I uploaded to the hub:

1 Like
3

doesnt need to be so complex.

use the current node.
if you select a collection column as the column to be filtered, you get 2 different scenarios:

  1. the reference column is a non-collection column: if any entry appears within the collection, its selected

  2. the reference column is a collection too: give us a toggle between
    2a) exact match (order and length)
    2b) (number of elements &) presence of all elements (same as exact match but without requiring the order)
    2c) any 1 element found being sufficient

you could divide 2b) further and 2a) is already working now anyway. But focus is anyway on 1)