Hi

I have an field container with different fields of an database table. On one field, there is an LOV. It´s values are depending on the current value of this field. This works fine. But after choosing an value from this LOV and saving it, the LOV shows all old values. I tried some dynamic actions to refresh the field with the LOV on it or its values. But it doesn´t work. After reloading of the page, it works.

I would be happy for some help.

Thanks in advance Christian

I created appl. 304. Start with page 1 and select the first row to get to page 2. There you have the field "status". My first question is, why is this field empty? The LOV returns values. There is the right data in the database table. I also activated "display extra values". The second question is, if you choose the next available values for "Status" and save, how do I refresh the LOV data because from now there should be another values available.

Thank you very much Christian

I´ve set it for this item, but no result.

Your test case is actually somewhat odd i.e. the LOV query and underlying data

select auf_status d, auf_status r
from status_lov
where von_status = :P2_STATUS

The reason why no record is shown is because there is no return value that matches the P2_STATUS value of "Erfasst" since you have reused the "auf_status" column again for the return value in the query.

If you change the query to:

select auf_status d, von_status r
from status_lov
where von_status = :P2_STATUS

It works just fine. In terms of refreshing the LOV just use a regular "refresh" dynamic action on the item on the appropriate event.

In terms of adding "forceSelection":false this will display extra values that are not within the list.

hi

changing the query would result wrong data. But for this I resolved the problem another way.

Dynamic action works now.

Kind Regards, Christian