In Oracle APEX, for a classic report, inside that to show nested reports, I am using Pretius APEX Nested Reports Plug In for this. In that query for it like:
SELECT la.customer, to_char(la.last_buy_date,'DD-Mon-RRRR') as "Last Buy Date"
FROM sirs_dwh_items_last_buy_mv la
WHERE la.catalog_part_number = '#CATALOG_NUMBER#'
order by 1;
I want to sort the records by the last_buy_date column in descending order, but i am not able to do that. I added order by col name desc in the query but it gives AJAX Call back error for the plug in. On the UI i tried to click on the column header to sort, but that also does not give sorted results.
This are the properties for the Nested Report Plug In i am using:
Please let me know if you need any further details on this!
Thank You.