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

21 Voters

POPUP LOV needs a remove value 'x' functionality

juanjfloresf Public
· Nov 14 2023

Idea Summary
New popup LOV needs to been able to remove selected value to allow null

Use Case
Using popup LOV as item type and setup to allow null values, once you change from null to a value, you cannot go back to null.

There is no way to delete assigned value on the item.

Changing to “manual entry” also removes the display value and only shows the return value.

Preferred Solution (Optional)
having an ‘X’ icon besides the LOV icon on popup LOV would be useful

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • yuri.kfreitas OP 5 months ago

    "We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future."

    I don't understand it, this is a very basic and essential thing that should exists in Apex.

  • vincent morneau Admin OP 5 months ago

    Of course. It's a balancing act with the other 300+ ideas that we deem important. There are also newer items with a more modern architecture (Combobox, Select One) that are designed with the X in mind from their inception.

  • mswvette OP 3 months ago (edited 3 months ago)

    Build a shortcut and you can clear many different widgets

    https://rimblas.com/blog/2020/06/use-apex-shortcuts-for-your-clear-item-button-or-link/

  • kevin.hewitt OP 3 months ago

    I agree with the comment from yuri.kfreitas.

    I had to explain to users that the screens that are written in APEX don't allow them to clear the value entered in Popup LOVs.  

    Their reply …. “But we can do this in the ‘old’ Oracle EBS [Forms Builder] screens.  Why can't we do it in the newer technology screens?”.
    I agree with them completely.  This isn't a nice to have - it's something very basic and essential.

    It doesn't make sense that we have to workaround this missing functionality by creating and coding separate buttons to allow the user to clear the fields.  This method also then looks different to the ‘clear field’ functionality that is built into the Combobox and Select One fields.

    Please can this be reviewed again.

  • jayson hanes Admin OP 3 months ago

    As mentioned by @mswvette this can be easily achieved in your apps with APEX Shortcuts, per the blog link shared. It is completely supported to do this that way. 

    (made his link clickable just now)

    I'm checking if there is an easier modern way or not.

  • kevin.hewitt OP 3 months ago

    Yes, I understand it can be achieved by implementing shortcuts, but this has two downsides in my opinion :

    1. It goes against the ‘low code / rapid development’ philosophy when you have to implement code to simply clear a field.  I've used many languages over the years and this is the first one where you have to use an additional piece of code to allow the user to clear the value they just chose.

    2. It has a different look and feel to the clear field functionality implemented for the 'Combo box' and ‘Select One’ fields.  If you wish to include both a Popup LOV and a Combo Box on the same page (as they have different uses), the user will have to use two different methods for clearing the fields, or the developer will need to use the same shortcut method that was used for the Popup LOV for both fields.

  • alexis galdamez APEX Team OP 3 months ago

    Hi @kevin.hewitt, 

    As Vincent mentioned the new items Select One has support for this use case, is there any use case where you need to stick with the Popup LOV as Select One doesn't fulfil your requirements? 

    Regards.

  • barry.brierley2 OP 3 months ago

    I'm with Kevin on this one. Pop-up LOVs are an Apex staple and it should not be hard provide the users with a clear button. As Kevin said, it has been a standard in the past and it makes it easier for us developers to generate acceptance from users when trying to persuade them to love Apex extensions on EBS.

  • a_machedon OP 3 months ago

    Hi Alexis, 

    From what I could notice, if multiple columns are available in the list, the Pop-up LOV type displays them in a table with header, as opposed to Select One type, which displays only one column with all the values concatenated and separated by a dash and no header - not very nice. 

    Regards,

    Alex

  • alexis galdamez APEX Team OP 3 months ago

    Yes, at the moment select one/many multi-column display is a concatenated list of each field, and the item also provides the freedom to the developer to provide an HTML expression if they would like a custom display. 

    Thanks for the feedback @a_machedon , I understand the limitation if you would like to display the results as a table.

  • kevin.hewitt OP 3 months ago

    Yes, displaying the results as a table is something we often need.  For example, to display a list of Customer Names + Customer Numbers.  Displaying as a table gives a good structure, and also allows the user to sort based on either column.