Hi,
I have a requirement where the client wants 2 buttons in each of the report column headers, One for Ascending Order Sort and the other one for Descending Order Sort. Clicking on these buttons would sort the entire column in the given order.
They want this feature in the infoview Web-I portal and not in any third party or java API portal.
Is this possible??
Thanks,
Jai
enjoyy2j 
(BOB member since 2008-04-17)
Hi -
Despite the obviousness of this requirement, this type of workflow is fairly difficult to achieve as it would require rework of the Infoview viewers. Your best bet would be to, from easiest to most difficult:
a) convince management that using Interactive Viewer right-click capability to “Sort” is sufficient or
b) create a custom viewer page or
c) “hack” at the existing Infoview viewers to create buttons/javascript to do this.
Sorting on columns via user interaction just isn’t something that’s been done yet. Hope this helps.
Atul Chowdhury (BOB member since 2003-07-07)
Thanks for the reply…
Option A & B is a No No.
Option C → ‘Hack’ you mean to crack the source code of BO Infoview and add those buttons…
As far as I know this feature cannot be implemented.
I found out something in this link:
I tried but it doesnt work the way it should.
Thanks,
Jai
enjoyy2j 
(BOB member since 2008-04-17)
Implementing the code in that link will only provide cosmetic changes required for your need - or - simply two buttons.
What you need is to re-tool the viewer and specifically hook into the BlockSort API and make that interact with your buttons/javascript.
There’s another way folks here have done it in the past, and that was to regenerate the Webi SQL but appending a “ASC” or “DESC” order by at the end of the clause. It’s somewhat useful but then things become more difficult with challenging data providers etc. This mostly leaves you back at a, b or c.
Good luck.
Atul Chowdhury (BOB member since 2003-07-07)