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

1 Voters

Let Shuttle Item handle large amount of selected items

weberge42 Public · Dec 5 2024

Idea Summary
Shuttle items is currenlty not able to process a large amount of selected rows. If the concatenated string (or JSON array) gets too big, an ORA-06502: PL/SQL: Character buffer too small exception is raised.

Since there is no Session State Data Type so select, its not possible to change this to CLOB

Use Case
e.g from our use case: assigning houndrets of users to a specific client in our administration app.

Preferred Solution (Optional)
No error.

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

  • vincent morneau Admin OP 9 months ago

    While this could surely be fixed, the Shuttle is not designed to be able to display 32k+ data. There is no search, groups or filter. For this kind of use case, I'd argue you should use a different item type. We may get to this this limitation in the future when Shuttle gets updated, but supporting this use case is currently not a priority.

  • kirsten OP 8 months ago

    Is there an idea for a workaround?

  • weberge42 OP 8 months ago

    @vincent morneau 

    >For this kind of use case, I'd argue you should use a different item type.

    Which one?

  • vincent morneau Admin OP 8 months ago

    The new Combobox or Select Many.

    A shuttle is really just the outcome of two select list with a fixed height put side by side, and a couple of buttons to help move entries around.

  • weberge42 OP 8 months ago

    both of them are not able to show more than 999 entries and are a bit cumbersome to use because they no not have a select all/select none feature.

    also, if i try to simulate all selected entries (=set source to “SQL Query (return single value)” which returns more than 32k, nothing is shown in the item.