We want to display an extremely complex query in the Web, which returns about 40.000 rows.
Our users are however only interested in the fifteen 'Overall result'-rows of this query. Therefore we try to find a possibility to suppress all the 'normal' data rows.
I have an idea, where in the Table Interface would like to try to "mark" these 15 rows each with a unique number (from 1..15, in an added column in my table). I would then want to sort this table according to my new column, thus giving me a table that first displays these 15 rows. Now I can set in the WAD: Display the first 15 rows.
Is this achievable? Could anyone provide coding examples that could help me do this?