Good morning,
I am looking for some help and after googling/searching the forum I have found no answer for my query(well that I can find I am sure someone else will have asked this). Please if someone has a link to help me by all means point me in the right direction.
My environment is APEX 5.1.2 Oracle 12cR2.
I am looking to add a functionality to the IG to have a button in the IG toolbar that will set all the current records the same value for a particular column. Now i have seen in the IG cookbook something similar called copy down but when i implemented it my user testing group didnt like the fact that you had to select the first record then hit the copy down button in the column header to do something simple. They just asked for a button to sit next to save to set the value which i thought was a fair ask.
If you look at my IG grid and filters below the only field I update is called "is viewable" (This is also a condition in the query of the IG so I have used Johns quick fix to stop the error of saving when changing a field in the grid that is a condition). Now the user case is that there could be a few hundred or just one record/s that come back depending on the filters used. Then from there the user will update all records to YES for is viewable using said button or manually select ones if that is required. So TL;DR we need a button to just set that value in the column for all rows viewable or all rows selected in row selector maybe?. Ideally it would be situation in the IG toolbar next to save to make the UX as best it can be which i can do following the hacking IF part 2. If i can get the logic sorted I will duplicate the button to do the opposite to set value to N
@"John Snyders-Oracle"
Hopefully I have explained things clearly and can get an assist as its my first time using the IG in a application.
Regards