7 Replies Latest reply: Jan 29, 2014 4:59 AM by RenédH RSS

Sorting on date (date_popup2) in manual tabular form does not work

RenédH Newbie
Currently Being Moderated

Hi All,

 

I created a manual tabular form (based on a collection) with 1 date_popup2 field in it. This field is defined in the query as follows:

 

,      apex_item.date_popup2( p_idx                   => 18
                            , p_value                 => c004
                            , p_date_format           => 'dd-mm-yyyy'
                            , p_item_id               => 'f18_' || lpad (rownum, 4, '0')
                            , p_item_label            => 'Start date'
                            ) as tf_br_start_date

 

In the report attributes I marked this column to be sortable.

 

However, in the page the sorting is not working. It looks like it's always sorted in the order  of the seq_id.

 

 

 

Can anyone tell me how to solve this?

 

Regards,

 

René

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points