Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle apex-Lock/disable specific columns in interactive grid

VinipandaMar 19 2021

I need to lock few columns in interactive grid for editing.
Ex:
image.png
Here the grey cells need to be disabled.
How can this be achieved? In case of sql we can right query using case to set flag.
Using those flags we can highlight cells using actions menu>format>highlight option.

Is there similar method to lock these cells as well?

Apex: 20.2

Comments

hari-Oracle

Hi,
You can use dynamic actions to conditionally enable/disable specific columns in specific rows. Please check below blog post which discusses few approaches.
Interactive Grid - Conditional Enable/Disable (0 Bytes)Regards,
Srihari

Vinipanda

Hi,
The disable works for me.I simply created dynamic action disable and in client side put all items for which i want the columns disabled. The cells are locked now. Is there also an option to color them via dynamic action? If not i will highlight them using IG highlight option.

hari-Oracle

Using declarative IG highlight is best option. It will cover all the cases for you.
Regards,
Srihari

Vinipanda

Hi,

I am using same logic to disable form items. Disable item a , based on value in item b. But the dynamic action is not working.
What could have gone wrong?

1 - 4

Post Details

Added on Mar 19 2021
4 comments
5,703 views