Oracle APEX version 21.3.2
Oracle Database version 19.0.0
I have an interactive grid with 2 columns that are editable (1 a date field, 1 a checkbox). The data for the IG is read from a collection which was populate upon entering the page via a Dynamic Action - On Page load from a database table. This is to keep track of choices made when going forward to other pages or coming back in case the user changes their mind.
Below is a screenshot of how the page looks rendered with rows 1, and 6 have only a date value upon entering the page.
All checkboxes “unchecked” initially are null or when going from CHECKED “Y” to Un-CHECKED have a value of “N”
Below is a screenshot of debugging page items I have displayed that captures each column's value for all rows in a delimited list (colon is my delimiter) while I test. The first item is the sequence ID generated when adding a new member to the collection.
Now upon entering this page, the user can check/uncheck a checkbox and also put in a new or update a date field. When this occurs, I have a Dynamic Action, and the Event when the action is executed is the one below from the documentation:
- Mouse Leave (
mouseleave) - Fires once when the pointing device is moved away from the triggering element.
Here is my left-hand side in Page Designer showing the IG-Interactive Grid and the two (2) columns use for updating with red-lines on the image, along with my DA an and Execute JS Code
The other columns in the IG are “read-only” or hidden.
In my DA, I execute JS (JavaScript) that will loop through the whole data model and assign each row's column value (for all columns I want to keep track of that are updateable) and stored them in page items in a delimited fashion. The problem is it seems that JavaScript or APEX, not sure which, can't keep up with my mouse movements, hence why not all the movements I made are captured in the page items. I'm usually pretty fast with the mouse and keyboard but even going slowly it still doesn't capture the last checkbox check I do.
Here's a screenshot AFTER I have made changes along with the values stored in the page items
Page Items:
The underlined “N”, should be a “Y” for Yes.
Now IF I then move the mouse around a little bit and THEN go to a button that is to go to the Next Page….THEN it updates it.
Obviously, I cannot have users worry about this, so my question is, is there a different DA Event that I should use other than “Mouse Leave”? I am an Oracle Database Developer, and not a JavaScript developer, but I am forced to learn enough JS that I need to get the task done. Or is “Mouse Leave” broken in my version. So far after Googling, I have found recommendations to use Mouse Over but that option does not exist in APEX but it is in JavaScript.
This is such a basic functionality yet spending time on something ideally so simple.
Thanks,