Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 442 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
LOV Dependent fields

Hi
I am on Jdev 12.2.1.4. I am checking if there is any property for my requirement below instead of wring code in ValueChangeListener.
I have 3 fields on my page. Field 1 is LOV. Field 2 is LOV, which is dependent on Field 1. Dependency os working great. I have a Field 3, which gets populated from Field 2 when LOV is selected as part of the LOV configuration based on List Attribute and View Attribute.
Problem is, when i select change the Field 1, Field 2 is reset to Null but Field 3 still having the old value. How can i make Field 3 as null as well?
Step 1:
Step 2: Language changed from French to Polish. Reason changed to null but TempBody still have value
LOV Configuration for Reason field. Comments attribute is nothing but Reason Field
Field 1: AutoSubmit: true
Field 2 : AutoSubmit : True and Partial Trigger: Field1
Field 3: AutoSubmit : True and Partial Trigger: Field1 and Field 2
Thanks
Lakshmi
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
I normally do this in the valueChangeListener.
The only other thing you can try is to set up dependencies of the attributes in the VO used. However, such dependency only works if the attributes are part of the same VO. I'm not sure this will work in your use case, I never tried.
Timo
-
I would implement a VO row impl class and modify the generated setComments() method there in order to clear the TempBody attribute whenever Comments attribute is being set to null:
public void setComments(String value) { setAttributeInternal(COMMENTS, value); if (value==null) { this.setTempBody(null); } }
Dimitar
P.S. @Timo Hahn , valueChangeListener is not the correct place to do that. First, valueChangeListener is part of the view layer. Second, valueChangeListener fires during "Apply Request Values" JSF phase. If there is some data error during "Validation" phase, "Update Model" phase will not be executed. In this way valueChangeListener would clear the attribute while the LOV stayed intact.