First pattern shows how to transform a flat list aggregate result into a nested list result. The typical use-case is to group results in a screen, so to nest two or more List widgets.
Second pattern shows how to apply a facet filter using an advanced SQL IN clause query.
This sample uses the OutSystems Sample database application. (Products)