Skip to Main Content

Java Development Tools

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!

Dynamically display table column based on column data (Show column when column data is Not null/ hid

Paul SusantoNov 11 2018 — edited Nov 11 2018

Hi,

JDeveloper Version: Studio Edition Version 12.2.1.2.0

Requirement: Let us assume, we have a table with data as shown below.

pastedImage_21.png

We will have a SelectOneChoice(LOV) component with the options to Select Gender. Based on the Gender selected, it should display the data in the table which will be just below the SelectOneChoice component. Now when we select Male as the Gender it should display all the four columns (ID, GENDER, NAME, PHONE_NUMBER ), but when we select the Gender as Female it should display only three columns (ID, GENDER, NAME) in the UI.

The reason why we don't want to show the PHONE_NUMBER field when the Gender is selected as Female, is because, for the Female we will not have an option to put PHONE_NUMBER , and hence the data for PHONE_NUMBER in the table is NULL for Female . Because of this reason, even we don't want to display the PHONE_NUMBER column in the UI as well, when the Gender is selected as Female.

Thanks & Regards,

Susanto Paul

Comments
Post Details
Added on Nov 11 2018
1 comment
58 views