APEX version is 21.2
Database is 19c (19.0).
I have a page item that is a “Select List” (aka an LoV [List of Values]) with a SQL query to bring up the list in an ordered way (via a column). This item is used to then trigger other LoVs which then allows the user to pick values and save a record.
My issue is after submitting the page, it reloads the page and re-runs the query to show the 1st value of the LOV query in the order defined. If the user selects another option within the list (anything but the 1st option), I'd like it stay there (remembered) after the refresh of the page? Is this possible?
I've tried one method where I remember the choice and use that hidden item in the base query of the LoV, yet it still reverts back to the 1st one in the list?
Here's an almost solution. I see the previous choice selected at the top “COMMACK”
But the one shown highlighted is what is chosen
Thoughts?
Thanks,