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!

Interactive Grid conditional highlighting

SinaApr 14 2017 — edited May 24 2017

Hello friends,

I have an Interactive grid form which i want to have conditional formatting.  Basically in the grid i have a column (COL_A) with shared component LOV and i want to have a cell background change (COL_B) based on the selected value of COL_A.

so i made a dynamic action under COL_A

WHEN

EVENT: Selection Change

SELECTION TYPE: columns

REGION: IG_REGION

COLUMN:  COL_A

CLIENT-SIDE CONDITION

TYPE: ITEM/COLUMN = VALUE

COMPONENT TYPE = COLUMN

COLUMN = COL_A

VALUE = 3

in True Action i have the following

IDENTIFICATION

Action: SetStyle

SETTINGS

Style Name:  background-color

Value: yellow

I made a similar thing for the False action

Now here are my problems

  1. The dynamic action fires up when ever i add a row to the grid and automatically false action being executed without me selecting or even clicking on COL_A
  2. The dynamic action fires right away when i click on existing row without even me interacting with any of the items in that row
  3. The background color only appear when i click on COL_B and as soon the cell looses focus it disappears and goes back to the original white background.
  4. Also i am not sure if the styles applies only to that cell or to the whole column.

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2017
Added on Apr 14 2017
13 comments
25,366 views