This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,798 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

Categories

LOV in a table refreshes the table to the old data.

Okan Sutcuoglu
Okan Sutcuoglu Member Posts: 121 Red Ribbon
edited May 2, 2018 2:32AM in JDeveloper and ADF

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.

Tagged:
Okan Sutcuoglu
· Share on TwitterShare on Facebook

Best Answer

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Consultant Cologne, GermanyMember, Moderator Posts: 39,055 Red Diamond
    edited Apr 30, 2018 6:28AM

    User, 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

    · Share on TwitterShare on Facebook
  • Okan Sutcuoglu
    Okan Sutcuoglu Member Posts: 121 Red Ribbon
    edited Apr 30, 2018 7:35AM

    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.

    · Share on TwitterShare on Facebook
  • RajuChetri
    RajuChetri Member Posts: 504 Blue Ribbon
    edited Apr 30, 2018 8:14AM 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.

    · Share on TwitterShare on Facebook
  • Okan Sutcuoglu
    Okan Sutcuoglu Member Posts: 121 Red Ribbon
    edited Apr 30, 2018 8:24AM

    No autoSubmit is false and i cant see changeEventPolicy  attribute for inputComboboxListOfValues or table

    · Share on TwitterShare on Facebook
  • Timo Hahn
    Timo Hahn Senior Principal Consultant Cologne, GermanyMember, Moderator Posts: 39,055 Red Diamond
    edited Apr 30, 2018 8:35AM

    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

    · Share on TwitterShare on Facebook
  • Okan Sutcuoglu
    Okan Sutcuoglu Member Posts: 121 Red Ribbon
    edited Apr 30, 2018 9:19AM

    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 ?

    · Share on TwitterShare on Facebook
  • Narendra Enamala
    Narendra Enamala Member Posts: 126
    edited May 1, 2018 1:31AM

    Hi Okan Sutcuoglu

       Can you set changeEventPolicy to None at bindings in a page so that row cannot be refreshed.

    pastedImage_2.png

    Regards

    Naren

    Okan SutcuogluOkan Sutcuoglu
    · Share on TwitterShare on Facebook
  • Daniel7777
    Daniel7777 JavaEE/ADF/SOA Consultant San JoseMember Posts: 7
    edited May 1, 2018 2:38AM

    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.

    · Share on TwitterShare on Facebook
  • Okan Sutcuoglu
    Okan Sutcuoglu Member Posts: 121 Red Ribbon
    edited May 2, 2018 2:32AM

    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

    · Share on TwitterShare on Facebook
This discussion has been closed.