We are unable to sort the data in the table/view in the object browser now. It causes lot of inconvenience. had to use sql commands always for sorting the data.
Please kindly provide the sorting if data in object browser.
Thanks
I just checked in 22.1 and 22.2, and there isn't any support to sort the data by column in SQL Workshop/Object Browser. Do you know what APEX version had that?
There is sorting option in both these versions. Please check the screenshot attached for the ordering of data in object browser in version 22.2.
Steps 1. Select any table/view from the object browser. 2. Go to data tab of the table/view. 3. Click query. 4. Scroll down to see the ordering option.
@basha.akbar the idea here is sorting in the data report (such as by clicking column headers), not during the query steps - that's a lot of extra clicks :)
sorry I didn't get it. u mean sorting it in UI. I want to sort the data while I am working in the object browser.
We reopened this idea to reconsider it again, and closed it again. For advanced data reporting, including sorting large data sets, we recommend using SQL Developer Web.