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)