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

22 Voters

Add a multi select list to the Item to Submit and Item to Return when passing PL/SQL back to server

wayne.taulu Internal · May 27 2022

Idea Summary
When you pass Pl/SQL back to server you have the option to Submit and Return item values.  Currently the submit and return is a text field separated comma value.  When you have a very large list of values being submitted or returned, it is very difficult to see what values you have in there and what might be missing.   I have to select the text, copy and paste it into a notepad and then I can read all the values to see what is there.  I have 2 options.

Option 1: Change the field from a text field to a multi select list.  This way you can see the list of every page item on the current page and just check off each one you want.

Option 2:  Get rid if this entirely and extract the Item names from the PL/SQL code itself.    If the PL/SQL code has a reference to :P1_ITEM then that should automatically be included in the submit.  If the code has return :P1_ITEM then the should automatically be included in the return.   This should be an optional setting so you can use the current method or this method.  This would save so much troubleshooting time when dealing with very complex PL/SQL and Item values.  I know I have wasted a lot of time over simple mistakes in adding the item to the Submit/Return.

Use Case
To reduce the amount of time dealing with troubleshooting problems from a simple mistake of forgetting to add to the submit or return

Preferred Solution (Optional)
Option 1 or 2 could simply be an optional select to switch to that method for each PL/SQL code so that the user can decide on which method they choose.  I know that if Option 2 was available, I would use that 95% of the time.

This request is likely a duplicate of FR-1729.

Known Duplicates

Known duplicates

FR-2686
FR-2686 Change comma separated Page Item Properties in Page Designer from Text Field to Text Area

Comments

Comments

  • fac586 OP 3.1 years ago

    I'd settle for the Items to Submit/Return property UI elements being multi-line text areas rather than text items…

  • colin.starkie OP 3 years ago

    I'd be happy if the Pick Items To Submit dialog contained a shuttle - easier to select items and see what is already selected.

    I currently use the https://www.foex.at/apex-builder-extension/ since they included the Automatically adding used page items to "Page Items to Submit" feature.

  • stew stryker OP 3 years ago

    BTW, we recently ran into the limitation that the Submit Items value cannot be longer than 255 characters. We had to shorten some page item names to accommodate it. You can say we shouldn't pass so many columns, but sometimes it's needed.

  • fac586 OP 3 years ago

    BTW, we recently ran into the limitation that the Submit Items value cannot be longer than 255 characters.

    That's a UI bug in previous releases (I hit it in 19.2). It has since been resolved—not sure exactly when—but in 22.1 the maximum field length matches the 4000 byte column size.

  • stew stryker OP 3 years ago

    @fac586 - thanks for letting me know it's fixed. Now I just have to get some bandwidth for our DBAs to upgrade Apex!