Sorting & Filtering in the same table

[Former Member]

Hello,

i had table with 5 entries in it.

First Column - a, ba, ab, aa, bb

Second Column - 4, 2, 1, 3, 5

I had sucessfully implemented Sorting & Filtering functionality to that table.

single Action:

1) when I sort 'First' column, as expected it is sorting that column - display 5 rows

2) when I filter 'First' column with value 'a', as expected it is filtering that column - display 4 rows (as 'a' is in 4 entries)

Double Action:

1) when I Filter 'First' column with value 'a', result displayed is 4 rows, then on that 4 entries when sorted the second column -- reuslt is good 4 entries (ie the sorting is done on the filtered entries)

2)Vice vesa, when i sort 'Second' column & Filtered the first column - the displayed result is not correct

First Option: (2 actions one after another) when sort second colum and then filtered the First column - result should be the sorted & filtered values of second column ignoring the first.(ie result should be -- a, aa, ab, ba, but filtering result is not sorted). How can i achive this?

if first option is not possible then second option

Second option: when i sort the second column & filter the first column, then the result should be -- Filted the first column & sort the second column and then the result should display (it should be like sorting is done on the filtered values).

Conclusion: If I filter a column, then filtered entries displayed should be in a sorting order (may be ascending).

Thanks

Maha

Edited by: Maha Hussain on Aug 6, 2009 12:02 PM

Edited by: Maha Hussain on Aug 6, 2009 12:18 PM

Edited by: Maha Hussain on Aug 6, 2009 12:25 PM

Edited by: Maha Hussain on Aug 6, 2009 12:56 PM

[Former Member]

Hi Maha,

Please go through this pdf you will get the solution definitely,

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f024364b-3086-2b10-b2be-c0ed7d33fe65

thanks,

viswa