5 Replies Latest reply: Sep 11, 2013 3:08 AM by AndyH RSS

    How to enable the end user to determine the sort type ?

    Test2

      Helllo All,,

       

      I use APEX 4.2.2 . Oracle 11.2.0.3.

       

      In a classic Rerpot (customized row template ), How to enable the end user to determine the sort type ?

      I use decode to choose the column according to which the sort is done, but how to determine : Asc / Desc ??

       

      order by decode(:P2_SORT, 'PRICE', v.PRICE, 'PROP_SIZE', v.PROP_SIZE , 'BEDS' , v.BEDS , 'AREA' , v.AREA) 
      

       

      Regards,