Question

Retrieve a list restricted by a list of items

4

Hi, I want to retrieve a list from the database and filter the items based of a second list. Almost like an inner join in SQL. But, I do not want to do this using a loop and querying the database for each line in the filter list. Regards

asked 2011-01-12

Danny de Beer

3 answers

Michel Weststrate · Answer 1 · 2011-01-12

You can retrieve both lists and check in a nested nested loop. No need to retrieve new objects for every line.

David Sanders · Answer 2 · 2011-01-12

Hi Danny

In a microflow, add a list/list operation action and do an intersect between the 2 lists

Danny de Beer · Answer 3 · 2011-01-12

I cannot do that, as the 2 lists are different objects, and that is not supported with list operation