Example of a problem I am facing:
I have an IG with an employee name column and one with an employee role. I am editing a few employees and defining their roles when I realise I need to add a new role.
I have a separate button outside the IG that launches a modal which adds the new role to the roles table. The role is added but this modal the page is submitted and dialog closed so the underlying grid page gives me the ‘Are you sure you want to leave…unsaved changes’ message. If I click OK I lose all my fields that were edited (but not submitted yet).
I've tried making this an inline dialog and using a DA to call the add_role proc then not submitting the page. This works but I can't figure out how I can refresh the roles column after the inline dialog is closed. If I use the refresh column DA is just tries to refresh the entire grid and I am left with the same issue.
I guess the underlying question is - Is it possible to refresh a column in a grid that is in an editable state without losing the value of fields being edited?
APEX 22.2
Thanks
Lee