Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 562 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 167 Java 8 Questions
- 86K Java Programming
- 81 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
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 537 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
LOV in a table refreshes the table to the old data.
Hello i hava a editable table and 1 column is LOV selection. But when i start to edit columns and select a value from LOV, it restarts the row and all changes goes.How can i fix this. I tried autoSubmit="false" but did not work.
Thank you.
Best Answer
-
is autoSubmit true for inputComboboxListOfValues if yes then we will loose the editable field values when we change LOV value. This behavior can be seen with input text with autosubmit true.
Just make sure to change the changeEventPolicy of table to none and add appropriate partial triggers.
refer the following post.
Andrejus Baranovskis Blog: ADF Editable Table - Recommendation For Data Entry Optimization
Regards,
Raju Chetri.
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,777 Red DiamondUser, tell us your jdev version, please!
How have you impemented the LOV in the table?
Have you written java code for this (then show it).
We need more info...
Timo
-
I am using JDeveloper 12.1.3. No i did not write a Java code i just have an editable table in a page.
I selected attribute as a LOV. Values comes from another view.
I dragged the LOV attribute to the table as a inputComboboxListOfValues.
-
is autoSubmit true for inputComboboxListOfValues if yes then we will loose the editable field values when we change LOV value. This behavior can be seen with input text with autosubmit true.
Just make sure to change the changeEventPolicy of table to none and add appropriate partial triggers.
refer the following post.
Andrejus Baranovskis Blog: ADF Editable Table - Recommendation For Data Entry Optimization
Regards,
Raju Chetri.
-
No autoSubmit is false and i cant see changeEventPolicy attribute for inputComboboxListOfValues or table
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,777 Red Diamond
The problem I see is that you did not define the LOV in the VO as an accessor. This can cause this behavior. Only if you define the LOV in the VO the model knows about it and handles it.
Timo
-
There is an accessor in VO. I use the same LOV VO for 2 attributes. But there is one accessor. Could this be the problem ?
-
Hi Okan Sutcuoglu
Can you set changeEventPolicy to None at bindings in a page so that row cannot be refreshed.
Regards
Naren
-
Good evening, instead of use that component in a table it is better to use either inputText or selectOneChoice and handle the events with the java code in valueChangeListener event.
By me experience I can tell you that the component that you are using in a table can lead you to hair pulling because (inputComboboxListOfValues) in iterations
can cause you troubles at long term when you need to customize it.
It is better to use that component outside of the table.
-
Thank you very much. You made me realize changeEventPolicy attribute is in the "Iterator" 's properties. I tried to find it in the table properties. So I made RajuChetri's answer was correct but thank you too