Hi all

I am strugeling with the TOP-N Function. I have a list with the quantity of some product families orderd by the highest quantity. The hole list is also filtered to different sites, where the parts are available. Sometimes there are mor then 10 product families per site. But I want to show only the 10 product families with the highest quantity. In a bar Chart or a pie Chart it’s possible to enable the TOP-N function. I have tried to get the wanted result in PL/SQL. I’ve found two ways to set the TOP-N function correctly in PL/SQL. Both of them won’t work in IFS.

In the first Option i’ve put the hole query in a SUBSELECT and set a filter on the ROWNUM. In the Datasourcedesigner I havn’t a Option, to enter a SUBSELECT over the hole query.

In the second Option i’ve use the FETCH command at the end of the query. But I can’t add this command in IFS.

Are there any other Solutions, to select only the 10 product families with the highest quantity and display the hole result in a list?

Thanks