Hello, I'm using Oracle APEX 21.2.0
My LOV_A has 3 columns and LOV_B has 5. I need to make the lov dynamically, display additional columns dynamically and lastly pick the output values for each lov dynamically as well.
When I create it inside the Shared Components and get the select using func body returning sql inside the “Additional Display Columns” the only columns that are showing are the columns from the last select I typed.
Please, help!
ps. Ive tried the Enhanced Lov plugin but there is no way to pick output values for the lov there. I've also tried a workaround to make two hidden lov columns and preventDefault the main lov button to click the hidden ones with js, but what if i have 50 lovs not just two?
If there is a way to custom template the columns shown in the lov and the output values via the initialization process of the column it would be great!