Skip to Main Content
Feature Request FR-3102
Product Area SQL Workshop
Status CLOSED

5 Voters

Should be able to sort the data of the table/view in Object browser

basha.akbar Internal · Apr 27 2023

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

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Known Duplicates

Known duplicates

FR-3464
FR-3464 Ability to Sort Data in SQL Workshop > Object Browser > Table

Comments

Comments

  • jayson hanes Admin OP 2.3 years ago

    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?

  • basha.akbar OP 2.3 years ago

    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.

  • jayson hanes Admin OP 2.3 years ago

    @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 :)

  • basha.akbar OP 2.3 years ago

    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.

  • vincent morneau Admin OP 7 months ago

    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.

  • pmushkov OP 3 weeks ago

    Object Browser is one of the most used APEX Developer tools. It is especially valuable for developers who don't have direct access to the database or don't have SQL Developer Web configured and accessible.
    It is also familiar to everyone using APEX and even if SQL Developer Web is an option, many people would prefer the APEX Object Browser interface.
    My opinion is that small improvements like sorting and enhanced filtering (similar to Interactive Reports) would make a big difference and would greatly be appreciated.