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_
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.