Microflow Aggregate List With Criteria?

Hi – I see how I can create a microflow to aggregate a list. What if I want to apply criteria on the list, i.e., filter the list for only certain values based on other column criteria in that entity, THEN aggregate it? Do I need to create a loop to look for that criteria and add to list? Thanks for any tips!
1 answers

Assuming the basic scenario, where you retrieve items from your database and then aggregate the list, you should add as many constraints in the XPath constraint of your retrieve. This is usually best for loading times (loops take a longer time than a single retrieve) and memory management (the aggregation is performed on the database, so the server memory is not used).