XML Hierarchy Select with pagination and order by

Hello Everyone,

I try to get some data using pagination and a specific order by, but it seems that the mention of the order by element doesn’t have any effect. The results will be always ordered by primary key ascending. If i remove the fields starting_row_number="0" ending_row_number="15" the order by works correctly.

I am missing something, or its not possible to have pagination with another order by except ascending by primary key ?
 

This is the XML used:

<hierarchy_select starting_row_number="0" ending_row_number="15">
  <primary_table>request</primary_table>
  <from>
    <table>request</table>
  </from>
  <attrs>
    <attr>request.request_id</attr>
    <attr>request.created_by</attr>
    <attr>request.created_dttm</attr>
    <attr>request.cust_prob_descr</attr>
    <attr>request.req_type</attr>
  </attrs>
  <order_by>
    <desc>request.created_dttm</desc>
  </order_by>
</hierarchy_select>

Kindly help me to do it if it is possible.

Thank you,

Constantin