13 Replies Latest reply on Feb 7, 2019 4:00 PM by Frank Hoffmann-colognedata

Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Jan 29, 2019 9:17 AM

Hi Friends

I would like to give the condition in From 12c from where the data is in table, when qty <= 0 Colour of that column cell should be read else it should be green.

and which trigger i will need to use and where .

Sanjay

1. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Amatu Allah Neveen Ebrahim Jan 29, 2019 11:26 AM (in response to SPathak)

Hi
I think you need to read about the visual attributes

IF :qty<0 THEN
SET_ ITEM_INSTANCE_PROPERTY ('BLOCK_NAME.ITEM_NAME', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_RED');
ELSE
SET_ ITEM_INSTANCE_PROPERTY ('BLOCK_NAME.ITEM_NAME', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_GREEN');
END IF;

POST-TEXT-ITEM OR WHEN-VALIDATE-ITEM Trigger

Amatu Allah.
Like Show 0 Likes(0)

Actions
2. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Jan 30, 2019 11:53 AM (in response to SPathak)

Sanjay,

the solution of Amatu will work but lead to a pretty colorful block. You might also loose you current record indicator.

Maybe it would make sense, to use only one item at the beginning of the block to mark your status and make this green, orange blue , gray or what ever you like..

like here:

Frank
Like Show 2 Likes(2)

Actions
3. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Jan 31, 2019 9:04 AM (in response to SPathak)

Dear Frank Hoffmann-colognedata

Actually I am trying to create the Display Form , where the user can see the status , if the qty is <= 0 then it should be Red , If its more then Buffer Stock then Green and if its below buffer stock then Yellow.

Sanjay
Like Show 0 Likes(0)

Actions
4. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Feb 6, 2019 3:42 PM (in response to SPathak)

Dear Friends
good day

I need when I run the program and the rack information table get executed with all records it should change the colour of complete row based on status T or false .
It tried with Post-text-item & When-Validate-Item with the following statment, but when i move the cursor that time only it changes the colour where as i want to display as soon as the form load with data.

IF :rackmaster.rack_available <=0 THEN
SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_STATUS', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_RED');
ELSE
SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_STATUS', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_GREEN');
END IF;

sanjay
Like Show 0 Likes(0)

Actions
5. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Amatu Allah Neveen Ebrahim Feb 7, 2019 12:22 PM (in response to SPathak)

Please try the same code with both Pre-text-item & Post-text-item.
Like Show 0 Likes(0)

Actions
6. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Feb 7, 2019 12:40 PM (in response to SPathak)

Sanjay,

place your display logic in the folowwing block triggers

WHEN-NEW-RECORD-INSTANCE
POST_QUERY

Will that work for you?
And center the item you want to have the color in.

Frank
Like Show 0 Likes(0)

Actions
7. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Feb 7, 2019 12:58 PM (in response to Frank Hoffmann-colognedata)

Dear Frank Hoffmann

Yes it worked, but only for those fields which are defined in the below line, where as i am looking for the complete line . otherwise then i will need to define each field.

POST-QUERY
IF :rackmaster.rack_available <=0 THEN
     SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_STATUS', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_RED');
     SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_AVAILABLE', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_RED');
ELSE
     SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_STATUS', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_GREEN');
     SET_ITEM_INSTANCE_PROPERTY ('RACKMASTER.RACK_AVAILABLE', CURRENT_RECORD, VISUAL_ATTRIBUTE, 'VA_GREEN');
END IF;

Sanjay
Like Show 0 Likes(0)

Actions
8. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Feb 7, 2019 1:28 PM (in response to SPathak)

Sanjay,

I would not do it. Make a Visual Atrribut (VA) with a nice light blue color like r75g88b100 and refer it as Current record Vissual Attribute Group on the desired items.
Please send us a screen shot from that again. I would prefer that as a user.

Frank
Like Show 0 Likes(0)

Actions
9. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Feb 7, 2019 1:28 PM (in response to SPathak)

and put your Status item on the left ...
Like Show 0 Likes(0)

Actions
10. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Feb 7, 2019 2:07 PM (in response to Frank Hoffmann-colognedata)

Hi

Now it looks like this.
Sanjay
Like Show 0 Likes(0)

Actions
11. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Feb 7, 2019 2:23 PM (in response to SPathak)

much better .. now you could add ROW Banding and some 16 Pixel Icons on the TAB Canvas and you would get the best Forms can do with 12.2.1.3

But most important you reached you goal already.
Like Show 0 Likes(0)

Actions
12. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

SPathak Feb 7, 2019 3:24 PM (in response to Frank Hoffmann-colognedata)

Hi Frank
How to do the row banding , can you please tell the steps.

sanjay
Like Show 0 Likes(0)

Actions
13. Re: Oracle 12 From - Change Colour of Rows & Column based on Condition

Frank Hoffmann-colognedata Feb 7, 2019 4:00 PM (in response to SPathak)

Sanjay,

please have a look at here .. https://community.oracle.com/blogs/oracleforms/2019/01/07/3-use-rowbanding-and-customcolorscheme-for-a-better-ux-on-multiblocks

If you made it post another screenshot so other Forms Developer can benefit or learn from your experience.

Frank
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.