Thanks for the question, Hritik.
Asked: July 05, 2023 - 4:39 am UTC
Last updated: September 04, 2023 - 2:05 am UTC
Version: 23.1.1
Viewed 1000+ times
You Asked
I want to create an editable grid using sql query. Like this
https://drive.google.com/file/d/1ubj4zPNuIyt3iC1VJBEB1k1OqIYeJlJp/view?usp=sharing in the rows there are files and in the columns there are the package names. If we tick a cell then the file will be included in the corresponding package. For example in the image above if I tick the cell corresponding row test1.txt and column 22000 then test1.txt file will be included in the package 22000.
Similarly if we untick any cell then the file will be removed from the package.
I have files and packages table. I have tried an interactive report for pivoting but there I am not able to edit the cell.(Tick and untick can be done using 1 and 0 too where 1 means tick, 0 means untick). And if i use an interactive grid then i am able to edit the cell but i am not able to pivot.
Any guidance will be highly appreciated.
Thanks
Hritik
and Connor said...
I spoke to Jeff Kemp, one of our resident APEX experts. He suggested a couple of things to explore
Approach 1. Choose a fixed maximum number of pivot columns, and based an Interactive Grid on a view that presents it as an ordinary table as far as APEX is concerned; a PL/SQL API (or view instead-of trigger) to translate back to the intersection table.
Approach 2. Build a completely custom dynamic solution, generating HTML + some fancy dynamic actions to handle immediate "Save" whenever a checkmark was changed in any cell (thus bypassing the builtin APEX submit processing).
For me, approach 1 seems the first thing I'd try.
Is this answer out of date? If it is, please let us know via a Comment