A Lobby List Element needs to show only the top 10 highest-quantity product families per site, similar to the TOP-N option available on Bar/Pie chart elements, but the Data Source Designer doesn't offer a way to wrap the whole query in a subquery with a ROWNUM filter, and using a FETCH clause directly at the end of the query isn't accepted either. Is there another way to achieve a TOP-N-style result in a List Element?

All FAQ questions / Platform, Aurena, and customization

Answer

Implement the ranking/TOP-N logic inside a proper IAL (a database view object) instead of trying to express it directly in the Data Source Designer's query box — build the IAL using either a subquery-with-ROWNUM approach or a ranking function, doing all the TOP-N filtering work inside that IAL itself, and then simply point the List Element's Data Source at that IAL. Since the IAL is a genuine database view, it supports the full range of SQL constructs, subqueries, ranking functions, FETCH clauses, that the Data Source Designer's own query editor doesn't directly support, giving much more flexibility for this kind of requirement.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions