Skip to Main Content
Feature Request FR-3830
Product Area Page Components
Status CLOSED

1 Voters

Pass custom sorting/ordering function to ORACLE APEX INTERACTIVE GRID CONTROL BREAKS

miguel escamilla Public · Jun 7 2024

Idea Summary
Pass a custom sorting/ordering function to the APEX Interactive Grid’s control break's direction. It only has an asc and desc option.

Use Case
The default ASC and DESC direction options are not what I need. I have a list of items. Each item belongs to a category. The control break works great to group them and show the header as the first row of each group. However, it orders the categories/groups/control breaks in desc or asc order only. But i need it to be a custom order. Each item has an index. I dont know how to get the control break to follow the order that I want.

Preferred Solution (Optional)
We need to be able to pass a custom function that the IG can take and display as an available DIRECTION option. I should be able to sort the CONTROL BREAKS other than by ASC & DESC order. I should be able to sort the control breaks by another column, the length of the string of each control break group, etc. It would make this IG richer!

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.

Comments

Comments

  • carsten.czarski APEX Team OP 1.2 years ago

    An easy way to achieve this would be to prefix the Control Break column with a numeric value, so that you get the values …

    • 1. Caulk & Paint
    • 2. Coatings
    • 3. Drip Edge
    • 4. EPDM

    From there on, the normal ASC or DESC sort will work just fine.