Refresh Table after commit

ChristianM0147

Hello

im currently working with JDeveloper version 12.2.1.4.0.

I have an entitybased ViewObject with a corresponding oracle database table.

I dragged the data control on my .jsf page to create a editable table. I can edit the records in the table and execute/commit the changes to the database table.

The problem is: the database table has a trigger that changes some values of the record in the database but it does not refresh the values of the table on my .jsf page.

I tried to set the 'CacheResults' property to false on the Iterator of the table in the Pagedefinition and set the 'partialTriggers' property of the table to the id of the commit button. But it does not work.

Any ideas?

Timo Hahn

Two things you can try

1) you go to the EO and for each attribute that is changed during commit by triggers, you set the checkbox 'Refresh on insert' and 'Refresh on update'

2) if 1) doesn'T work, you can execute the query behind the table again.

Timo

Timo Hahn

Two things you can try

1) you go to the EO and for each attribute that is changed during commit by triggers, you set the checkbox 'Refresh on insert' and 'Refresh on update'

2) if 1) doesn'T work, you can execute the query behind the table again.

Timo