In this case, I'm attempting to find the intersection of two lists. For example, List_A = (a, b, c, d. e) and List_B = (c, e, f). The intersection of List_A and List_B is List_C = (c, e). In PHP, one can do this:

$List_C = array_intersect($List_A, $List_B)

But we do not have such functions in Creator.

Now imagine a database where we have 100's of "List_A" records that contain any number of a, b, c...x, y, z elements. How can one identify all the records that match some arbitrary List_B? There are ways to use "for each list-element" type checks, but they quickly run into the maximum #deluge limits.

Any ideas?